Post reply

To convert Existing Data in SQL to UTF-8 Format

  • December 11, 2003 at 6:14 am

    #106658

    Hi DBA's,

    I got an issue when website is supporting multiple collations. BA need to include UTF-8 formats to support various languages when website is running. So existing data is not appearing in UTF-8 format, so they started re-building the application with UTF-8 Format. Now the Issue is by using DTS, can we import the old data in UTF-8 format. Suggestions are welcome. How to import the old data in new DB which supports UTF-8 format?

  • December 19, 2003 at 5:13 am

    #487185

    Hi Folks,

    I got a solution in this, after some research. The Problem here is, UTF-8 data, which is already stored in SQL Server, you cannot convert UTF-8 data directly in another Server, which will become junk,

    For this you need to use bcp utility(bcp out), with codepage RAW and get the data, and convert it to UCS2 format and bcp in

    with -w format. I posted here, because someone may face the same problem. Any clarification regarding this, please mail me i will send you the list of steps that need tobe carried upon.

    Thanks,

    Adiseshan C.B>

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

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