Entry

I have russian strings in my tables .These strings are fetched improperly. what should I do?

Apr 27th, 2005 05:44
Keyar Srinivasan, Maxim,

SQL Server stores based on the codepage of the database!
For example:
If your client is using codepage 850 and the database 1250 you will have
automatic conversion.
If your client is using having a ASCII variable stored in codepage 850 
and
your stored this in a Unicode column on the server, by default this 
will get
converted to the server side codepage first. You can also convert it to
Unicode on the client first and insert it, in which case it will got in 
as
is.
Please read:
International Features in Microsoft SQL Server 2000
http://msdn.microsoft.com/library/e...lserver2000.asp
PRB: SQL Server ODBC Driver Converts Language Events to Unicode (234748)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;234748
INF: SQL Server 7.0 BCP and Code Page Conversion (199819)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;199819