Re: Searching/inserting certain Unicode characters
Posted by: Peter Gulutzan
Date: March 06, 2011 01:48PM

mysql> create table m1 (s1 varchar(50) character set utf8);
Query OK, 0 rows affected (0.12 sec)

mysql> insert into m1 values (concat('abc',0xc2a0,'def'));
Query OK, 1 row affected (0.04 sec)

mysql> select * from m1 where s1 like concat('%',0xc2a0,'___');
+----------+
| s1 |
+----------+
| abc def |
+----------+
1 row in set (0.00 sec)


Peter Gulutzan
Oracle / MySQL

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Searching/inserting certain Unicode characters
2972
March 06, 2011 01:48PM


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.