Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 BCP'ing data containing foreign characters into a table?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-12 : 09:23:10
John writes "As the subject suggests, I'm trying to BCP data from a text file into a table. The data contains several foreign characters (á, ä, ß, ü, etc...), that are not copied properly. Once in the database (MSSQL Server 6.5), they show up as various "normal" letters and symbols.

The code page we're using will accept the characters, the problem seems to lie within BCP itself. I've heard rumblings that BCP for 6.5 only copies up to a certain point in the ASCII character set and does not include the characters I'm trying to copy, but I've been unable to find any good, concrete information on the subject.

To the point, is what I'm trying to do possible in 6.5?

Thank you,

John"
   

- Advertisement -