|Anonymous | Login | Signup for a new account||2021-01-24 05:39 GMT|
|Main | My View | View Issues | Change Log | Roadmap|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000937||SiT!||sites & contacts||public||2009-09-12 14:35||2013-01-05 15:59|
|Product Version||Current SVN|
|Target Version||3.90beta1||Fixed in Version|
|Summary||0000937: Branch3 SVN - Clicking on the DK Letter Å shows results from A|
|Description||In Contracts, Contacts, and Sites|
clicking on Å gives results of A
|Tags||No tags attached.|
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.
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..
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
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
|This will be resolved by 0001146|
|2009-09-12 14:35||Tomse||New Issue|
|2009-09-12 14:38||ivan||Relationship added||related to 0000910|
|2009-09-12 15:39||ivan||Assigned To||=> kieran|
|2009-09-12 15:39||ivan||Status||new => assigned|
|2009-09-12 15:39||ivan||Target Version||=> 3.50|
|2009-09-12 16:14||ivan||Assigned To||kieran => ivan|
|2009-09-12 19:32||ivan||Relationship added||related to 0000936|
|2009-09-13 11:22||ivan||Note Added: 0001964|
|2009-09-17 15:31||Tomse||Note Added: 0001977|
|2009-09-17 17:13||ivan||Note Added: 0001988|
|2009-09-17 17:13||ivan||Target Version||3.50 => 3.60|
|2009-09-17 17:14||ivan||Note Edited: 0001988||View Revisions|
|2010-03-14 12:41||ivan||Note Added: 0002680|
|2010-03-14 12:41||ivan||Target Version||3.60 LTS => 4.0|
|2010-03-14 12:49||ivan||Relationship added||parent of 0001146|
|2010-04-06 20:03||paulh||Severity||trivial => minor|
|2011-02-14 13:21||ivan||Target Version||4.0 => 3.90beta1|
|2013-01-05 15:59||ivan||Note Added: 0004629|
|2013-01-05 15:59||ivan||Status||assigned => resolved|
|2013-01-05 15:59||ivan||Resolution||open => not fixable|
|2013-01-05 15:59||ivan||Status||resolved => closed|
|2013-01-05 15:59||ivan||Assigned To||ivan =>|
|Copyright © 2000 - 2021 MantisBT Team|