1

I am using BCP to import and export data, but some of it is in an asian language (think chinese or korean). It is stored correctly in the SQL, at least that's what I see from SSMS, though the collation is Latin1. However, when using BCP the export doesn't output the data in the right language anymore.

I used the options -w and -N but neither worked.

Jorge Guzman
  • 489
  • 1
  • 4
  • 16
  • when you use the -N flag the data is exported in Native format which is basically binary data. How do you know that the output data is not in the right format? The only way to know is to import into another table. – Dharmendar Kumar 'DK' Dec 02 '11 at 19:51

0 Answers0