View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000053 | WackoWiki | action | public | 2007-08-31 15:24 | 2009-10-13 16:05 |
| Reporter | EoNy | Assigned To | Tann San | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | resolved | Resolution | duplicate | ||
| Product Version | 4.2 | ||||
| Target Version | 5.0.beta | Fixed in Version | 5.0.beta | ||
| Summary | 0000053: PageIndex sort wrong with capital ans non capital Letters | ||||
| Description | Insert Wiki entry "Lara, Laura, lana, Zender," (see lower an upprer case letters). pageindex show: L: Lara,Laura Z: Zender L: Lana FIX: in /action/pageindex.php : Change: $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." to $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. | ||||
| Tags | No tags attached. | ||||
| has duplicate | 0000330 | resolved | administrator | Wrong sorting pages named in Russian on Index page. |
|
|
charset issue |
|
|
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. |
|
|
wakka.config.php: “db_collation” => “0”, "0" OR http://dev.mysql.com/doc/refman/5.1/de/charset-we-sets.html |
|
|
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. |
|
|
this affects ORDER BY |
|
|
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: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html 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. |
|
|
Is this still an issue? |
|
|
see bug 0000330 |
| 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 |
