List:General Discussion« Previous MessageNext Message »
From:Michael Monaghan Date:December 5 2008 7:24pm
Subject:Re: How to create a unicode capable table??
View as plain text  
I'm not at all familiar with SQL Server, but you need to make sure that the
encoding/charset you use in MySQL is the same as used in SQL S.

If not the same, then you might need to transcode the data before migrating.

Collation is less important than encoding. - if you get the charset wrong,
then your data can become garbled. The collation can be changed after the
fact.

The encoding/charset you would typically use in a multilingual environment
is utf8. [In fact, you can use this all the time, unless you've got a good
reason not to]. The utf8 charset has the default collation of
utf8_general_ci. - That collation is less than perfect, - utf8_unicode_ci is
more accurate, but slower. However, collation might not be an issue for you.
See http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html.


hth.
~mm

On Thu, Dec 4, 2008 at 1:01 PM, Ali, Saqib <docbook.xml@stripped> wrote:

> Hello,
>
> Any thoughts on this? Thanks.
>
> On Tue, Nov 25, 2008 at 8:14 PM, Ali, Saqib <docbook.xml@stripped> wrote:
> > What Charset and Collation should I use while creating a mysql table
> > such that it can take data from unicode SQL Server DB table?
> >
> > Thanks
> > saqib
> > http://doctrina.wordpress.com/
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
How to create a unicode capable table??Saqib Ali26 Nov
  • Re: How to create a unicode capable table??Saqib Ali4 Dec
    • RE: How to create a Unicode capable table??Jerry Schwartz4 Dec
    • Re: How to create a unicode capable table??Michael Monaghan5 Dec