clickhouse-odbc icon indicating copy to clipboard operation
clickhouse-odbc copied to clipboard

Unable to retrieve german umlauts from ClickHouse using ODBC (only)

Open esanumIT opened this issue 2 years ago • 4 comments

Hi,

we got lots of (unicode encoded) German Umlauts in our Clickhouse DB, which are retrieved fine, when selecting via the JDBC Connector within DBeaver, but using the ODBC Connector in Dbeaver (we need the data to be available via ODBC for other tools, but for simplicity of the bug report, I did set both up in DBeaver), we get broken characters back, eventhough we're using the Clickhouse ODBC Unicode driver!?!

String in the Database (for potential reproducability?): "3 Impfpassbeispiele: Wie hätten Sie entschieden?" Quiz auf esanum – Ihr Ergebnis

Result using the JDBC Driver: image

Result using the ODBC Driver: image

Driver used in ODBC: image

Any suggestions/ideas?

esanumIT avatar Jan 09 '23 10:01 esanumIT