|
|
Posted by Erland Sommarskog on 09/09/05 00:13
(geekboyed@gmail.com) writes:
> I'm outputting a file from a mySQL server that contains 1 column that
> has input it many languages. The base definition for the column is
> UTF8.
>
> I output the data into a flat file and bcp it to a sql2000 server, and
> the multi-byte data does not survive the translation.
>
> Any ideas on how to input a UTF8 flat file into the server using BCP?
Since you cannot store UTF-8 data in SQL 2000 in any civilized way,
you need to first convert the file to UCS-2. (Or UTF_16 if you prefer.
I hope you are not using surrogates.)
A simple way to do this is to open the file in Notepad, and then change
encoding when you do Save As.
I'm a little uncertain how any byte-order mark would affect BCP.
Notepad is likely to add one, but I don't know if BCP is smart
enough to ignore it.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|