Post reply

How to control character set in DTS?

  • May 22, 2003 at 8:52 pm

    #106082

    When importing a DBF file into a SQL server using DTS, sometimes the right character set will be deduced, sometimes it will not (even for the same file at different times), resulting in garbled text appearing in the database.

    I can't for the life of me find out how to tell SQL server which character set the DBF file is in. It all seems to be automagically done, and done wrongly.

    I've researched this for several weeks. Please help me. Any suggestions are good.

    (The text I'm importing is in Chinese.)

  • May 26, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • June 9, 2003 at 9:45 am

    #460400

    SQL server uses Coding Page to figure out character set properties. If you are using bulk insert task to import your data , it provides 3 choices, however, in your case you can specify the Coding Page to Chinese. Take a look at Online help "code page".

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

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