ClickHouse / ClickHouse/clickhouse-odbc

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

Open
#417 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
285
Forks
105
Avg merge
3h 56m
Merged PRs (30d)
3

Description

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](https://user-images.githubusercontent.com/18008180/211291370-33cb397b-9d17-40ce-bc0e-270d6611b166.png)

Result using the ODBC Driver:
![image](https://user-images.githubusercontent.com/18008180/211291433-4fba9c4f-bb74-4910-aea3-3ff3fb4d4fc4.png)

Driver used in ODBC:
![image](https://user-images.githubusercontent.com/18008180/211291731-5aecbdac-bd36-4750-862c-0af2a68eb1bd.png)

Any suggestions/ideas?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.