1267 Illegal mix of collations
- cortez8591
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
- Thank you received: 0
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:
how to fix that?
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.
- cortez8591
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
- Thank you received: 0
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";
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.