Post reply

Internationalization: exporting using bcp

  • January 8, 2004 at 6:16 pm

    #84344

    I'm trying to load data extracted from sql server(Cp1252) to an oracle(UTF8) database using bcp.

    But this is failing because of invalid characters in the files extracted from sql server. Interesting thing is that when I save the bad file as UTF8 using emEditor, that loads fine.

    Now the question is, can I somehow export the file from sql server in UTF8? Is this possible?

    I tried the -w option in bcp sommand to export as unicode, but that didn't seem to help.

    Any suggestions?

  • January 8, 2004 at 6:34 pm

    #489265

    I've found that BCP is a bit limiting when using unicode characters. I would either use a linked server and transfer the data across the linked server or use a DTS Package for this. DTS seems to handle the unicode data better than BCP for some reason.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

  • January 8, 2004 at 9:05 pm

    #489274

    Thanks for responding.

    But at this time we are limited to use bcp as this is part of a generic publishing application involving different kinds of databases.

    Would appreciate if somebody can respond if they had similar issues and how they approached solving it.

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

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