Re: Collations and REGEXP
Posted by: Alexander Barkov
Date: April 25, 2006 03:48AM

by the way, the above syntax works fine too:

mysql> show create table t1;
+-------+--------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`a` varchar(64) character set utf8 collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+--------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select a, a rlike '[[:<:]]test[[:>:]]' from t1;
+---------+------------------------------+
| a | a rlike '[[:<:]]test[[:>:]]' |
+---------+------------------------------+
| test | 1 |
| testing | 0 |
+---------+------------------------------+
2 rows in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
2585
March 10, 2006 04:05AM
1658
April 25, 2006 03:34AM
Re: Collations and REGEXP
1595
April 25, 2006 03:48AM
1769
May 17, 2006 10:58AM
1687
June 08, 2006 05:28AM


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.