TagCharacter Set

MySQL Collation Error

M

Occasionally I come across databases written by other developers who have a complete mix of character sets, and where the database character set does not match the character set of fields within a table. This causes all sorts of nasty errors when trying to use CONCAT or CONCAT_WS. Errors like: Illegal mix of collations for operation ‘concat_ws’) The most common cause is that the...

Archive

Tags

Get in touch

I'm available on just about every social media platform out there as RMTWeb.