Asked By denis.carabadja
08-Dec-07 05:11 AM
I found a solution.
SQL Server uses UCS-2 encoding, but Informix Database Server - UTF-8.
And I tried different ODBC and OLEDB drivers and they didn't
converted
from one encoding to another.
But, I am lucky :), I found a solution. I am using CLR possibilities
of SQL2005 and created a function that converts data from one
encoding
to another (http://msdn2.microsoft.com/en-us/library/ms160893.aspx).