Re: i don't understand the significance of character_set_connection

[Donal Lynch]

The only effect I've been able to find is on the character set of string literals, so you might see different results for charset('foo'), hex('foo'), and length('foo') depending on the connection_character_set. But if you insert 'foo' into a column it gets converted to that column's character set, and if you select 'foo', it gets converted to character_set_results when it gets sent down to you, so you're right, it doesn't seem to be something that has very many consequences.