Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.1-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE test1 DEFAULT CHARACTER SET utf8; Query OK, 1 row affected (0.00 sec) mysql> USE test1; Database changed mysql> CREATE TABLE table1 ( text1 TEXT, FULLTEXT index_ft (text1) ); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vorvan'); Query OK, 1 row affected (0.00 sec) mysql> SET CHARACTER SET utf8; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vorvaň'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vörvaň'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vörváň'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vorváň'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vorván'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('vórván'); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM table1; +-----------+ | text1 | +-----------+ | vorvan | | vorvaň | | vörvaň | | vörváň | | vorváň | | vorván | | vórván | +-----------+ 7 rows in set (0.00 sec) mysql> SELECT * FROM table1 WHERE MATCH (text1) AGAINST ('vorvan'); ERROR 1030 (HY000): Got error -1 from storage engine mysql> INSERT INTO table1 (text1) VALUES ('any text'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('another text'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('some text'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('text'); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO table1 (text1) VALUES ('empty'); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM table1 WHERE MATCH (text1) AGAINST ('vorvan'); ERROR 1030 (HY000): Got error -1 from storage engine mysql> SELECT * FROM table1; +--------------+ | text1 | +--------------+ | vorvan | | vorvaň | | vörvaň | | vörváň | | vorváň | | vorván | | vórván | | any text | | another text | | some text | | text | | empty | +--------------+ 12 rows in set (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('empty text'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('nothing'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('anything'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('something'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO table1 (text1) VALUES ('some thing'); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM table1 WHERE MATCH (text1) AGAINST ('vorvan'); ERROR 1030 (HY000): Got error -1 from storage engine mysql> SELECT * FROM table1 WHERE MATCH (text1) AGAINST ('vörvan'); ERROR 1030 (HY000): Got error -1 from storage engine mysql> SELECT * FROM table1 WHERE MATCH (text1) AGAINST ('vörvaň'); ERROR 1030 (HY000): Got error -1 from storage engine