Re: ODBC and Unicode

Alain Migeon schreef:
> Hi
>
> I have a database on Oracle 10g using AL32UTF8 character set.
> The NLS_LANG is also set to this character set.
>
> The database contains data with cyrillic characters.
>
> I am accessing my database in C++ through ODBC. There is no problem to
> get the correct string that contains these cyrillic characters.
>
> However, when reusing without modification these cyrillic characters
> within a query through a where clause passed through SQLExecute, it
> doesn't return anything.

And how did you do that? using some client side tool? cut-n-paste? Di you realize the OS you work on actually has to map those characters? By doing so, they may have gotten a different codepoint.

Best to set NLS_LANG to what is actually running on your client, e.g. WE8MSWIN1254 (if that is the correct codepage for cyrillic)

There's a fine note on Metalink regarding Facts, Myths and Errors on NLS_LANG - a must read. Misconception #1: NLS_LANG must match the DB charset.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...