Posted by Erland Sommarskog on 06/21/07 22:16

P?vels Mihailovs (iceravenlv@gmail.com) writes:
> I have a problem. I've linked MySql server to MsSql, in MySql I have a
> table with Latvian data(character set is ucs2, ucs2_general_ci) and
> the problem is that when I use openquery to read data from MySQL
> server, some characters are not translated correctly! I receive
> question symbols instead of Latvian special characters.
> Maybe someone had this kind of problem with collation?

Since I don't work with MySQL myself, it's difficult to say what is
going on. But if MySQL has a notion of collation, and the collation is
ucs2_general_ci, it sounds like MySQL returns Unicode data. One would
expect that to arrive unscathed. What is you collation on the SQL
Server side?

The stored procedure sp_serveroption permits you to set options for
linked servers, and two of them relates to collations. You could play
around with these and see what happens. Please look in Books Online
for details.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Data base encodings
• Prev in forum: Re: Migrating SQL 2000 to SQL 2005
• Thread view: Re: MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem.

[Reply to this message]