All Questions

Tagged with
Filter by
Sorted by
Tagged with
6
votes
3answers
3k views

Why are there different levels of MySQL collation/charsets?

Looking at the MySQL server variables the server and database collation are set to latin1_swedish_ci but the collaction_connection is utf8_general_ci. Additionally, the collation/charset is set at ...
1
vote
1answer
722 views

MySQL collate error occurs when sent by PHP app but does not occur in phpMyAdmin

I have a query that uses: t3.`value` LIKE "%someval%" COLLATE utf8_general_ci I load the page in my browser and get this error printed to the screen: COLLATION 'utf8_general_ci' is not valid for ...