odbc extension supporting (full) unicode characters

[Jos Geerts]

Hi all,

Is it a big effort to change the existing odbc driver to support unicode
(I need this to access databases with unicode data - chinese, japanse,
cyrillic - character sets?

Currently the driver/extention automatically change the data to ansi
characterset, and that makes the data unusable as the data cannot be
converted from multibytes to just a single byte.

I did try to cast the data as "binary" and that worked, I retrieved the
data as-is, no conversion was done, so the unicode data was complete. The
problem is that not all sql languages support binary (Impala SQL does not
support it), so it's not always possible to cast the data as binary.

So I'm a bit stuck here... :-(

Any help/ideas would be welcome.

Thanks,