CODEWITHSUNDEEP
sqlsql-server
Bohn
Bohn

Reputation: 26919

Finding a special character in one of the columns of many tables

The import is causing a crash because of invalid character for XML that is coming from client's SQL Server data. From the log file looks like it is a right arrow "->" .

All I know is it is coming from a column - I don't know which column - in one of my tables - about 20 tables -

How can I give them a query to run on their database to find out where is this bad data located ?

Upvotes: 0

Views: 303

Answers (1)

takintoolong
takintoolong

Reputation: 138

I was having a similar problem. I found the characters by using Notepad++. There is a menu for encoding. Changing this causes some hidden characters to appear. I changed it to ANSI. Also, I have found hidden characters in Microsoft Word using the "Show or hide formatting marks" button.(It looks like a backwards P).

Upvotes: 1

Related Questions