Post reply

Importing Chinese text file on an English OS

  • August 2, 2004 at 3:28 am

    #164566

    I have SQL Server installed on an English OS. I have a client with Chinese XP OS and Enterprise manager installed. I need to import a text file with Chinese text. When importing manually from Enterprise Manager on Chinese XP connecting to the Sql Server 2000 installed on the English 2000 OS everything imports fine. But if I simply create a DTS to do the import it imports garbarge.

     

  • August 2, 2004 at 5:01 am

    #517213

    Do you import it into  NVARCHAR, NCHAR, NTEXT fields?

    If you try and import it into VARCHAR, CHAR and TEXT fields then the characters will simply convert into the low byte ASCII representation.

    The other thing is to display the characters properly you will need a unicode font such as ARIAL Unicode.

    To test whether it is a true import error, or a display error find try SELECT UNICODE(<<your character>&gt against a character in both versions of your database.  If you get the same value then it isn't an import error.

    LinkedIn Profile

  • August 2, 2004 at 5:23 am

    #517221

    Yes they are all nVarchar fields. I can read the data by opening the table directly from enterprise if it's imported correctly. with analyzer i'd only be able to read it under Chinese OS. 

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply