|
Notes |
|
|
(0001964)
|
|
ivan
|
|
2009-09-13 11:22
|
|
ok I found the answer to this but it complicates things a bit. mysql treats 'A' and 'Å' as equivelant with utf-8 general collation, it will also sort them incorrectly. Å will come before Z.
The correct way to solve this is to use 'utf8_danish_ci' collation. I'm not immediately sure of the implications of changing this, and obviously this means we need to do something during setup so that we use the correct collation. |
|
|
|
(0001977)
|
|
Tomse
|
|
2009-09-17 15:31
|
|
Thinking internationally here..
this might complicate things if, say
2 support departments
1 in DK
and another 1 in russia
but that also opens up pandoras box.. |
|
|
|
(0001988)
|
|
ivan
|
2009-09-17 17:13
(edited on: 2009-09-17 17:14) |
|
Unfortunately due to it's complexity this one is not gonna be resolved for 3.50. I hope this doesn't cause too many problems for people.
@tomse: yeah I thought of that too, it's going to need some thinking about this one
|
|
|
|
(0002680)
|
|
ivan
|
|
2010-03-14 12:41
|
|
Confirmed that changing the collation to 'utf8_danish_ci' fixes this issue (for Danish). There's nothing we can really do to fix this for 3.x since we're feature frozen and it would mean adding more code to support multiple collations.
It does complicate things when SiT! is being used in an international situation. I'll add some documentation (somewhere?) about using other collations and maybe we can look at making the setup let the user choose the collation to use in 4.x |
|
|
|
(0004629)
|
|
ivan
|
|
2013-01-05 15:59
|
|
|