1267 Illegal mix of collations

9 years 8 months ago #7474 by cortez8591
When I try to search through my site and I put a character like ąźćę etc it gives me following output:
1267
Illegal mix of collations (latin1_general_cs,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT * FROM hba71_sef_redirect WHERE CONVERT(source USING latin1) COLLATE latin1_general_cs = 'search/?searchword=testować' AND published='1' LIMIT 1

how to fix that?

Please Log in or Create an account to join the conversation.

9 years 8 months ago #7477 by cortez8591
site\parse.php:124
by default string searches in mysql are case insensitive so this conversion is not needed and moreover is causing problems. one should stick to utf8_general_ci and don't worry about that.

if it is opensource I would send You a patch ;)
$query = "SELECT * FROM #__sef_redirect WHERE source=".$db->Quote($requested_uri)." AND published='1' LIMIT 1";

Please Log in or Create an account to join the conversation.

About us

We provide high quality Joomla components created by a co-founder and original core developer of Joomla. For over a decade, our products have been used by more than 20.000 webmasters around the world.

Stay in touch