Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
SQL Server GroupsView
SQL Server Ce
SQL Server Clients
SQL Server Connect
SQL Server Datamining
SQL Server Datawarehouse
SQL Server Dts
SQL Server Fulltext
SQL Server Msde
SQL Server Olap
SQL Server Replication
SQL Server Reportingsvcs
SQL Server Security
SQL Server Server
SQL Server Setup
SQL Server Tools
SQL Server Clustering
SQL Server Programming
SQL Server Xml
SQL Server Newusers
SQL Server Integrationsvcs

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft SQL Server Programming Posts  Ask A New Question 

Connection problem to Informix from SQL Server 2005 with Unicode data

denis.carabadja posted on Saturday, December 08, 2007 5:08 AM

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:
=E8 '=E5=B7 =E5=8C-=E5|=E5=B7=A5=E6=A5=E6 =AA=E51/4 =E41/4=9A=E7=A43/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
reply

 

I found a solution.

denis.carabadja posted on Saturday, December 08, 2007 5: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).
reply


Previous Microsoft SQL Server Programming conversation.