Denis Glazachev

> reproduce same behavior with playground Are you trying with `isql`/`iusql` or your application?

Let's make sure we reproduce things with `isql` so I can reproduce them myself too.

> `ClickHouse DSN play=ClickHouse DSN play` Shouldn't this be `ClickHouse DSN play=ClickHouse ODBC Driver (Unicode)`? > `Driver=ClickHouse ODBC Driver (UNICODE)` Could you also change this to `Driver=ClickHouse ODBC Driver (Unicode)`...

You still have `Driver=ClickHouse ODBC Driver (UNICODE)`. `UNICODE` -> `Unicode`.

Can you please send the content of `~/.odbc.ini`, `/etc/odbc.ini`, `~/.odbcinst.ini`, `/etc/odbcinst.ini` separately?

> `cat ~/.odbc.ini` If the file is empty, just remove it. Add `SSLMode=allow` under `[ClickHouse DSN (Unicode)]` and try again. What is the output of `ldd /usr/lib64/libclickhouseodbc.so` and `ldd /usr/lib64/libclickhouseodbcw.so`...

Hm, I think I know what is happening. `/lib/x86_64-linux-gnu/libiodbcinst.so.2` is from `libiodbc2`. Are you sure your application is using iODBC? This is very unlikely in Linux, the de-facto standard there...

> work with iusql, but not with 1C ... That's a progress. And there was an obvious issue... What exactly doesn't work in 1C right now? Have you made sure...

If some obvious lib usage issues are sorted out, please describe the problem you are seeing with 1C right now?

It's fine, we can use this issue. > 1C use UTF-16 in internal representation - and on screenshot drop every 2 symbol Looks like a typical wide-char issue between UnixODBC...