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
 General SQL Server Forums
 New to SQL Server Programming
 Special Characters

Author  Topic 

dundealing
Starting Member

12 Posts

Posted - 2008-03-10 : 05:52:09
Hi,

I an concatenating a string using char(187) as the separator. When I run the command "select char(187)" I get the symbol >>

However, when it writes to a csv file it is showing as an overscore instead.

Is there a known problem with special characters when writing to files?

ranganath
Posting Yak Master

209 Posts

Posted - 2008-03-10 : 06:14:32
Hi,

please provide sample data
Go to Top of Page

dundealing
Starting Member

12 Posts

Posted - 2008-03-10 : 06:38:47
It turns out that BPC is causing the problem. I will look into it and get back to you if I find anything.
Go to Top of Page
   

- Advertisement -