Convert Data in a txt file to utf-8 format

I am trying to import data from a text file to a SQL2000 table as utf-8 formate. The data in the text file is in Chinese and not in utf-8 format. This will need to be done with a Scheduled DTS.
awu25Asked:
Who is Participating?
 
jdlambert1Commented:
Hmm. Try changing your local code page -- even if your OS is in English, you can use a non-English Collation.

"In Control Panel, find the Windows locale name in the Regional Settings application (Microsoft® Windows NT® 4.0, Microsoft Windows® 98, and Microsoft Windows 95) or the Regional Options application (Microsoft Windows 2000), and then use this table to find the corresponding Collation Designator and code page:

Windows locale, LCID (locale ID), Collation designator, Code page
Chinese (Taiwan) 0x30404 Chinese_Taiwan_Bopomofo 950
Chinese (Taiwan) 0x404 Chinese_Taiwan_Stroke 950
Chinese (People's Republic of China) 0x804 Chinese_PRC 936
Chinese (People's Republic of China) 0x20804 Chinese_PRC_Stroke 936
Chinese (Singapore) 0x1004 Chinese_PRC 936
0
 
jdlambert1Commented:
Shouldn't be a problem if you make the destination table first, using the nchar or nvarchar datatypes. This stores unicode (UCS-2). Then just use DTS normally. No collation specifications are necessary for storing Chinese characters in a unicode column, but you might want to consider specifying a Chinese collation for the column when you create the table (simplified or traditional) if you're going to order output based on it.
0
 
awu25Author Commented:
I have done all that. If I use the Enterprise Manager installed on a Chinese XP and import the file manually without going thru DTS then it works fine. It is when I import from an English OS does it import garbage.
0
 
awu25Author Commented:
Problem solved by chaning the windows locale. Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.