broken cyrillic search engine April 12, 2020, 05:22:17 PM I ask for help, when I search in the standard search engine for tables in the Cyrillic alphabet, it gives an error, in the Latin alphabet and the search in numbers is normal, but not in the Cyrillic.Error Message | SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'like'File | /app/models/PDODb.php On Line 1045Stack Trace | 1 app/models/PDODb.php(1045): PDOStatement->execute() 2 app/controllers/Test_tableController.php(71): PDODb->get('test_table', Array, Array) 3 unknown file(unknown line): Test_tableController->index() 4 system/Router.php(196): call_user_func_array(Array, Array) 5 system/Router.php(109): Router->run('test_table') 6 index.php(106): Router->init() Quote Selected
Re: broken cyrillic search engine Reply #1 – April 13, 2020, 09:16:52 PM @kvad please provide details of your database collation. Quote Selected
Re: broken cyrillic search engine Reply #2 – April 14, 2020, 11:09:41 AM Hi,I use XAMPP server, MySql, utf8_general_ci, and I don't have problem with search in cyrillic! How ever for me there is an issue with the export in pdf, doc . Could you export table in pdf/doc that include Cyrillic? Quote Selected
Re: broken cyrillic search engine Reply #3 – April 17, 2020, 07:14:26 PM @dobsun for search error, use this utf8_unicode_ci collation instead. and make sure all fields on that table apart from Auto-Increment PrimaryKey uses it too. Quote Selected
Topic: broken cyrillic search engine (Read 947 times)
previous topic - next topic
Track issues, Ask questions, Make suggestions,Report a bug