[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
http://t3test.xetpoint.com/index.php?id=673
and look at the source code of pi1-file - maybe it gives
some advice.
More information about the TYPO3-english
mailing list