MySQL Forums

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.