MS SQL Server - Conversion of cyrillic ASCII characters to "???"

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Conversion of cyrillic ASCII characters to "???"

Thomas

2006-10-24, 6:38 pm

Hello
A client application (Informix Enterprise Gateway) writes cyrillic ASCII
strings to SQL Server 2000 (SP4) table. All cyrillic characters are converted
to "???".
Configuration:
- Windows 2003 Server Enterprise (english, multilanguage russian), CLuster
- SQL Server 2000 SP4 (english setup, language changed to "russian" after
installation)

It seems that the ODBC-driver converts all charaters to a latin codepage and
all settings in the connection-string (language=russian, autotranslate=no) or
collations are ignored.
We tried without success all possible types: nvarchar, char, text, ntext,
varbinary,...

How can the codepage conversion be influenced ?
It is not possible for us to change the client´s behavior.
We checked the incoming data with an ethernet sniffer - they are OK (cyrilic
ASCII).

Regards
Thomas

Sponsored Links