Re: Searching/inserting certain Unicode characters
Posted by: Kai Schaetzl
Date: February 21, 2011 07:49AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Searching/inserting certain Unicode characters
3296
February 21, 2011 07:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.