|
Posted by denis.carabadjac on 12/05/07 13:41
I have Informix 9.4TC6 and SQL Server 2005.
DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372).
First, I created DSN to Informix. Then tried to get data with WinSql
tool and it works fine.
But when I created linked server in SQL Server 2005 I have problems
with languages other than English.
I get a string like:
è 'å· å-å|å·¥æ¥æ ªå1/4 ä1/4ç¤3/4
It seems to me that SQL Server splits 2-byte characters in 2 1-byte
characters.
If in options of linked server we set Collation Name to exact
language
we want --> then string data will be correct (of course only of
language that we choose).
Do you have any suggestions?????????
P.S. I don't want to use SSIS (DTS) for extraction from Informix DB
[Back to original message]
|