BCP import of special characters....

[sanjith]

In using BCP to import records into a table SQL server, but the records to be imported are having special characters, im able to Import the data but the special characters are not Importing Properly.....

Need help from you guys, to solve this problem....

Eg : Calle Miguel Ángel 24, piso 3, Interior, Izquierda -- Record to be imported.
----

[ck9663]

Try using a format file to specify a more flexible data type of your target table.

Good Luck !!!

~~ CK

[sanjith]

Thank you so much ck9663 from your reply.....

The format cannot be changed as it TABLE defined.... is there any other options??

[ck9663]

Yes, import it to a different table first :)

Good Luck!!!

~~ CK

[sanjith]

Hi Ck....

I have tried the options told by you.... but in still getting the same error...

Can you plzz provide me someother solution for this stopping issue...

[ck9663]

Here, read this. Try to play around with the CODE PAGE parameter.

Good Luck!!!

~~ CK