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
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.
On Thu, Dec 4, 2008 at 1:01 PM, Ali, Saqib <docbook.xml@stripped> wrote:
> 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