Connecting Tech Pros Worldwide Forums | Help | Site Map

BCP with special chars

Newbie
 
Join Date: Jul 2008
Posts: 1
#1: Jul 31 '08
Hi,

I am trying to upload file having special characters (Turkish).
The column contains data like -> aşağıdaki
When I run bcp, it gets converted to -> asagidaki
format of the input file is unicode.

1. What changes do i need to do in format file to get actual value in database?
2. Collation of database column should be changed so that it is compatible with the above data. Is this correct?
3. Are there any links I can refer for - uploading data from various languages (french, Greek, Turkish) in database?

Really need help on this..
Thanks!

Reply


Similar Microsoft SQL Server bytes