View Issue Details

IDProjectCategoryView StatusLast Update
0000053WackoWikiactionpublic2009-10-13 16:05
ReporterEoNy Assigned ToTann San  
Status resolvedResolutionduplicate 
Product Version4.2 
Target Version5.0.betaFixed in Version5.0.beta 
Summary0000053: PageIndex sort wrong with capital ans non capital Letters
DescriptionInsert Wiki entry "Lara, Laura, lana, Zender," (see lower an upprer case letters).

pageindex show:

in /action/pageindex.php :
$sql = "select ".$this->pages_meta." from ".$this->config["table_prefix"]."pages where ".
"latest = 'Y' and LEFT(supertag,7)!='comment' order by BINARY tag limit ".$offset."


$sql = "select ".$this->pages_meta." from ".$this->config["table_prefix"]."pages where ".
"latest = 'Y' and LEFT(supertag,7)!='comment' order by tag limit ".$offset.",".(2 * $limit); ,".(2 * $limit);

AND in mysql change in table prefix_tag, field tag
from latin1_bin to other where make an better sorting for it.
TagsNo tags attached.


has duplicate 0000330 resolvedadministrator Wrong sorting pages named in Russian on Index page. 



2007-10-15 05:24

administrator   ~0000144

charset issue

Tann San

2007-12-17 01:18

manager   ~0000237

I made the changes as listed below with a few minor fixes to correct typos. I also modified the install script to accomodate this with the SQL change.

It does fix this issue but I'm not sure if it has messed up sorting for foreign characters.

Can you give me 3 pages using german characters at the start that I can test on my local copy please along with the instructions for what the correct sort order should be. I'll get 3 more pages from one of my swedish friends as well.


2007-12-18 06:07

administrator   ~0000246


“db_collation” => “0”,

"0" OR

Tann San

2007-12-18 15:16

manager   ~0000251

to tell you the truth I'm not sure what the collation option does, I know what it does in the code and to SQL but I'm not sure what the result is. I'll read up on it.


2007-12-18 20:03

administrator   ~0000253

this affects ORDER BY

Tann San

2007-12-19 16:19

manager   ~0000256

so you haven't actually said if it's messing up your characters. I just requested the swedish test data from a friend of mine so hopefully I can test it out this week. I read this link which told me what SQLs SET NAME= does:

very good read. means I could of skipped the changing the column type in SQL but I think in the longrun it made sense to do that anyway. it was set for binary before.

Tann San

2009-04-09 20:01

manager   ~0000632

Is this still an issue?


2009-10-10 21:28

administrator   ~0000690

see bug 0000330

Issue History

Date Modified Username Field Change
2007-08-31 15:24 EoNy New Issue
2007-08-31 15:24 EoNy Legacy => NEW
2007-08-31 21:02 administrator Legacy NEW => NPJ
2007-09-17 19:06 administrator Summary PageIndex sort wrong wit capital ans non capital Letters => PageIndex sort wrong with capital ans non capital Letters
2007-09-17 19:06 administrator Description Updated
2007-10-15 05:24 administrator Note Added: 0000144
2007-12-01 15:35 Tann San Status new => assigned
2007-12-01 15:35 Tann San Assigned To => Tann San
2007-12-17 01:18 Tann San Note Added: 0000237
2007-12-17 01:18 Tann San Status assigned => feedback
2007-12-18 06:07 administrator Note Added: 0000246
2007-12-18 15:16 Tann San Note Added: 0000251
2007-12-18 20:04 administrator Note Added: 0000253
2007-12-19 16:19 Tann San Note Added: 0000256
2009-04-09 20:01 Tann San Note Added: 0000632
2009-10-10 21:27 administrator Relationship added has duplicate 0000330
2009-10-10 21:28 administrator Note Added: 0000690
2009-10-10 21:29 administrator Status feedback => resolved
2009-10-10 21:29 administrator Resolution open => duplicate
2009-10-10 21:29 administrator Fixed in Version => 5.0.0
2009-10-10 21:29 administrator Target Version => 5.0.0
2009-10-13 15:58 administrator Target Version 5.0.0 => 5.0.beta
2009-10-13 16:05 administrator Fixed in Version 5.0.0 => 5.0.beta
2010-03-08 10:09 administrator Category Action => action