[TYPO3] Re: Problem ordering characters åäö in typo3

Tapio Markula tapio.markula at atwebteam.com
Fri Sep 15 11:43:24 CEST 2006

typo3 at mrbrown.se kirjoitti:
> A while ago I made an extension for typo3 using the guide kickstarter
> guide. The extension is made for storing resellers and listing them in FE
> ordered by name. The problem is that it seems like typo3 somehow have a
> problem reading the letters å ä ö and putting them correctly in a sorted
> list.
> In mySQL the code for åäö is showed as;
> å = ä
> ä = ä
> ö = ö
> It seems like typo3/mySQL orders the resellers using the specific mySQL
> code and because of it the letters å ä ö is sorted in wrong order. I tried
> to change the DB to utf-8 and I also tried with latin_swedish_c1 but none
> of these shows my list in correct order. I can’t figure out how to solve
> this problem but hopefully someone on this list has the solution.
> /E
In sp_directory this was handled internally and that order could be
changed. I changed it to support ä,ö etc. in Swedish/Finnish order.
download evaluation version of sp_directory from

and look at the source code of pi1-file - maybe it gives
some advice.

More information about the TYPO3-english mailing list