[TYPO3] Problem ordering characters åäö in typo3

Dmitry Dulepov typo3 at accio.lv
Fri Sep 15 13:27:19 CEST 2006


typo3 at mrbrown.se wrote:
> 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.

You may want to search mailing list archives for the answer. Firsts, you 
need to setup initialization commands to mysql correctly (like SET NAMES 
utf8) and set up mysql locale correctly.

Dmitry Dulepov

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)

More information about the TYPO3-english mailing list