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)
 BCP Unicode field terminator

Author  Topic 

B0g
Starting Member

19 Posts

Posted - 2008-07-01 : 09:22:29
Hello,
I am trying to export some data though BCP in a Unicode file. I want to use a Unicode field terminator, but BCP change that Unicode character. Do you have any idea about how to export a Unicode character as a field terminator (like let’s say a Chinese symbol)?

10x
B0g

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-07-01 : 09:40:00
you specify the column delimiter in bcp with the -t arg.


elsasoft.org
Go to Top of Page

B0g
Starting Member

19 Posts

Posted - 2008-07-01 : 09:55:40
yeah... I know the argument for field terminator, my problem is that it does not accept Unicode character...
Go to Top of Page
   

- Advertisement -