List sort problem with local diactric

[procajlok]

Hello!
I have a problem with sort table by column, where words sometimes start by diactric polish letter - ? , ?, ?...
Records with this word go to the end of the table - this is wrong. Order must be a,b,c,d,e...l, ?, m, n, ?...
How can i fix it? Please help...

Best regards

 

[troester]

Check your database collation settings.
I had the same problem with German umlaute: the default utf8-general-ci is sorting wrong (resp. following other sorting rules).

Try to set one of your columns to collation = utf8-polish-ci
If this is working:
Backup your database, then set your collation to utf8-polish-ci.
I think for existing table columns you have to do it per column.

 

[procajlok]

Do you mean, i must change this two field in list options?

Or change DB collation in phpMyAdmin ?

Regards

 

[troester]

I would try to change the collation of one column in phpMyAdmin to see if this solves your problem.

As far as I can see changing the list collation (in list settings) won't change existing column collations.

 

[procajlok]

You're great! After change column collation in phpMyAdmin it works!
Very, very thank you!!