[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