-- MySQL dump 10.2 -- -- Host: localhost Database: test1 -- ------------------------------------------------------ -- Server version 4.1.1-alpha /*!40101 SET NAMES utf8*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */; -- -- Table structure for table `table1` -- DROP TABLE IF EXISTS table1; CREATE TABLE table1 ( text1 text, FULLTEXT KEY index_ft (text1) ) TYPE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table1` -- /*!40000 ALTER TABLE table1 DISABLE KEYS */; LOCK TABLES table1 WRITE; INSERT INTO table1 VALUES ('vorvan'),('vorvaň'),('vörvaň'),('vörváň'),('vorváň'),('vorván'),('vórván'),('any text'),('another text'),('some text'),('text'),('empty'),('empty text'),('nothing'),('anything'),('something'),('some thing'); UNLOCK TABLES; /*!40000 ALTER TABLE table1 ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;