Hi.
Detailed description with screenshots:
http://mrg.risp.pl/stuff/collate-problem.php
Other observations:
1. character_set_results are default set to latin2. Then results returned by simple php test script (connect & select) are displayed properly in browser ( <meta ..... encoding="utf8"> included in <head></head> )
2. Setting character_set_results to NULL or utf8 causes inproper displaying, like the browser didnt know to display utf8 data.
3. Running script that inserts UTF8 string (prepared by gedit - 100% proper utf8) causes:
- data is inserted like it was latin1 or latin2 (? probably..),
- it is properly displayed when rest of rows are displayed badly, and vice versa.
So it is strange situation: I set EVERY variable that has "character_set" in its name to utf8, then insert UTF8 string, and i get something that is probably not UTF8...
The main problem is: how to sort utf8 column with utf8_polish_ci collation.