How delete these characters ß Ð by hexadecimal mysql

Asked Feb 16 '17 at 22:44

Active Feb 16 '17 at 23:01

Viewed 36 times

I try to remove theses characters ß Ð but I see the only way to remove only this characters is by hexadecimal I try use

DELETE FROM table
WHERE field like '%ß%'

DELETE FROM table
WHERE field LIKE CONCAT('%',CHAR(195,159),'%')

but dont work corretly and delete another rows more data without this symbol

edited Feb 16 '17 at 23:01

asked Feb 16 '17 at 22:44

Jessica Paloma

http://stackoverflow.com/questions/8994821/how-to-find-certain-hex-values-and-char-values-in-a-mysql-select – McNets Feb 16 '17 at 22:45
http://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql – McNets Feb 16 '17 at 22:46
I try both tutorial but dont work – Jessica Paloma Feb 16 '17 at 22:57
I don't exactly know why because I'm not good with regex, but it works: http://rextester.com/SPG31375. Look at comments on the first answer. http://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql – McNets Feb 16 '17 at 23:09
What collation do you have set for your field? – Michael Krikorev Feb 16 '17 at 23:25
utf8_general_ci – Jessica Paloma Feb 16 '17 at 23:28

0 Answers0