Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-04-25 16:33:49
- ultramega
- Member
- Registered: 2006-02-26
- Posts: 221
Non-english characters & alphabetical sort?
TXP seems to understand letter Ä as A. It’s quite disturbing, when you list articles, and titles like
kärlek
are before title
karneval
The Ä is one of the latest characters in our alphabets. Any way to fix this?
Offline
Re: Non-english characters & alphabetical sort?
It’s MySQL that does the sorting. Which MySQL version are you using and in what language does ä come at the end of the alphabet?
Offline
#3 2007-04-25 20:38:56
- ultramega
- Member
- Registered: 2006-02-26
- Posts: 221
Re: Non-english characters & alphabetical sort?
Ok, that sounds reasonable. The mysql version seems to be 4.1.15. The Ä is at the end of alphabets for example in swedish and finnish.
Can that be fixed via phpMyAdmin? I’m not very familiar with it, so any help is welcome :) I have now there about 200 posts, hopefully messing with this doesn’t hurt them…
Offline
Re: Non-english characters & alphabetical sort?
You can probably fix this by setting the correct collation
Offline
#5 2007-04-26 11:08:57
- ultramega
- Member
- Registered: 2006-02-26
- Posts: 221
Re: Non-english characters & alphabetical sort?
Thanks. Looks bit spooky to me :)
I found there is a swicth in the phpMyadmin settings, where one can set character sets of the table. If I switch that to correct position, has anyone empiric info how that affects existing txp-data? My site is almost ready, and just haven’t time to take a risk something goes wrong…
Offline
Re: Non-english characters & alphabetical sort?
collate doesn’t alter data, only sorting. Check the MySQL manual.
Offline
#7 2007-04-26 18:18:20
- ultramega
- Member
- Registered: 2006-02-26
- Posts: 221
Re: Non-english characters & alphabetical sort?
Let’s do so. Thanks, both of you.
Offline