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 2005 Forums
 Transact-SQL (2005)
 bulk insert and special character

Author  Topic 

wendyl
Starting Member

1 Post

Posted - 2008-01-28 : 00:56:07
i need to copy data from a file which contains special characters like é,ô etc. can anyone pls help me out.. thanks

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-01-28 : 10:28:46
bcp will copy all special characters that it sees.. Isnt't that the case ?
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-01-28 : 18:48:56
Have you looked at format files?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-28 : 20:05:58
And you can specify code page with -C option.
Go to Top of Page
   

- Advertisement -