MySQL Forums :: Perl :: Case-insensitive text search doesn't work


Advanced Search

Case-insensitive text search doesn't work
Posted by: Alexey Surikov ()
Date: October 14, 2009 01:36AM

Hello,

when I run fulltext search query ( match(...) against(...) ) with cyrillic input text it works as case-senstitive. The text stored as "Москва" can be selected with "Москва" only, not "МОСКВА" or "моСквА".
Why is this so? I expect it to be case-insensitive.

PS: I changed collation of the text column to utf8_bin. Didn't help.

My envirioment:
---
mysql> desc zip; <-- working table
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| zip | char(6) | NO | MUL | NULL | |
| name | text | YES | MUL | NULL | |
+-------+---------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> show variables like 'character_set%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

mysql> show variables like 'collation%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
---
This is perl, v5.10.0 built for i486-linux-gnu-thread-multi
---
DBI v1.607, DBD::mysql v4.010
---



Edited 2 time(s). Last edit at 10/14/2009 02:00AM by Alexey Surikov.

Options: ReplyQuote


Subject Written By Posted
Case-insensitive text search doesn't work Alexey Surikov 10/14/2009 01:36AM
Re: Case-insensitive text search doesn't work Rick James 10/15/2009 10:23AM


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.