Re: Searching/inserting certain Unicode characters

[Kai Schaetzl]

Thanks, I've been able to work this out after a hint on Usenet that I can only use 0x character syntax.

UPDATE table SET fr=REPLACE(fr, ' ?',CONCAT(CHAR(0xc2a0),'?')) WHERE fr LIKE '%?%'
SELECT fr FROM table WHERE fr LIKE CONCAT('%',CHAR(0xc2a0),'?','%')

Your given select statement doesn't really work for real-use scenarios, e.g.
SELECT hex(fr) FROM table WHERE fr LIKE '%0xc2a0%'
doesn't work.
Also, I can't come up with a working REGEXP syntax. Am I correct in assuming that I can't use REGEXP to look for this type of character? e.g.
SELECT fr FROM table WHERE fr REGEXP '0xc2a0'
doesn't find anything.