Re: Searching/inserting certain Unicode characters
Posted by: Peter Gulutzan
Date: February 27, 2011 11:43AM


The "given select statement" that you refer was this:
mysql> SELECT hex(utf8) FROM table_name WHERE utf8 = 0xC2A0;
| hex(utf8) |
| C2A0 |
1 row in set (0.00 sec)
There are no single quote marks around 0xC2A0.
Your addition of single quotes is what caused failures.
The string should be all hex, or CONCATenated with other strings.

Peter Gulutzan
MySQL / Oracle

Options: ReplyQuote

Written By
Re: Searching/inserting certain Unicode characters
February 27, 2011 11:43AM

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.