Re: Connection problem to Informix from SQL Server 2005 with Unicode data

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).