March 2, 2006 at 1:19 pm
I recently migrated data drom database A to Database B. I used a DTS package to map the fields and copy the data over. Most of my data came over OK. But in some instances, I have strange characters:
 (Looks like if there was a SPACE at begining , don't know for sure)
Æ (Appears to be in place of an apostrophe)
û
ô (Appears to be in place of a starting quote)
ö(Appears to be in place of an ending quote)
My question is, how do I tell SQL Server to replace them with what they should be?
Collation-Alternate dictionary order, case-insensitive, for use with the 850 (Multilingual) character set.
March 5, 2006 at 10:24 am
After cosiderable digging I found this:
Search and Replace SQL Server data in all columns, of all tables
It was a stored procedure that would search and replace in all tables in a database. With a few exceptions, it worked briliantly. The author's name is Narayana Vyas Kondreddi.
It can be found at:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply