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

• Next in forum: Re: Add a datestamp to an existing table
• Prev in forum: Re: Can anyone help with waittype 0x0044?
• Thread view: Connection problem to Informix from SQL Server 2005 with Unicode data

[Reply to this message]