MySQL Forums
Forum List  »  Perl

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
October 14, 2009 01:36AM


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.