I am having an issue where there are special characters being output to a file using bcp. The characters don't appear in the database but are in the file.
For example. Our db shows a row with data as follows:
On the bcp using the -c option the output in the file is
Are the special characters in the db but I can't see them? Is there a way to determine this?
We are running SQL Server 2005 but set to 2000 compat level.