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.
| Author |
Topic |
|
diegolaz
Starting Member
6 Posts |
 Posted - 2009-10-01 : 08:39:01
|
| Hello, after some database migration and changes in my database appeard some strange symbols, and I can't identify them all...I manageed to fix most (80-85%) of the bad chars with:UPDATE defs SET def = REPLACE(def, '–', '-')UPDATE defs SET def = REPLACE(def, '“', '"')UPDATE defs SET def = REPLACE(def, '� ', '"')UPDATE defs SET def = REPLACE(def, '�.', '".')UPDATE defs SET def = REPLACE(def, '�,', '",')UPDATE defs SET def = REPLACE(def, '�)', '")')UPDATE defs SET def = REPLACE(def, '�<', '"�<')UPDATE defs SET def = REPLACE(def, '�;', '"�;')the main one I'm missing that I'm not sure what it is is •Is there an exhaustive list where I can find all †combinations??Thank you! |
|
|
chrisbarba
Starting Member
2 Posts |
Posted - 2009-12-21 : 00:23:19
|
| I think has something to do with not being UTF-8 encoded.How about something like this.This will return all the data where not normal.SELECT def FROM defsWHERE column_name NOT IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'A', 'a', 'B', 'b', 'C', 'c',.....etc)Chrishttp://chrisbarba.wordpress.com |
 |
|
|
|
|
|
|
|
replace strange symbols