[Typo3] Another sorting problem

Dmitry Dulepov typo3 at fm-world.ru
Fri Aug 12 12:13:35 CEST 2005


Hi!

I think it is related to MySQL character set of your tables. Use
"myisamchk --set-character-set=latin2 tableFile.MYI" to change the
character set. Before doing this make sure that:
- you have created an index on that column
- mysql is stopped when conversion is performed

Dmitry.

Piotr Burda wrote:
> My site is in Polish, encoding iso 8859-2, when i`m sorting my adress
> table by town i`ve strange behavior when name of the town starts with
> polish character,
> you can see it here
> http://www.fuchs-oil.pl/index.php?id=151&no_cache=1&tx_pbfuchsdystrybucja_pi1[pointer]=1&tx_pbfuchsdystrybucja_pi1[mode]=1
> 
> 
> town Srem (with accent on S), should be sorted after towns which name
> startw with S (without accent) but it is sorted always at the end of list.
> 
> How can i change it?
> 
> Piotr



More information about the TYPO3-english mailing list