Re: CAST(expr AS CHAR) - default charset & collation

[Dale Greenlee]

In my project I got this error also. I wish it had given a line number for the offending '='. I entered your suggestion (show variables like '%coll%') and got this:

+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+

So, how do I get them all to agree?

Thanks,

Dale