Re: MySQL + Collation (utf8_swedish_ci){urgent}

[Rick James]

First, is the database incorrect, or is the select incorrect? This might answer that question:

Arbetsförhållanden

SELECT LENGTH(col), CHAR_LENGTH(col), HEX(col) FROM tbl;
_should_ give you 18, 20, then 20 hex pairs, including double characters for the accented letters.

If you don't get 18 and 20, then you (probably) _inserted_ the text without properly using SET NAMES utf8.

If you do get 18 and 20, then your settings are (probably) incorrect for the _select_.