View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000216 | WackoWiki | unicode | public | 2008-08-10 19:34 | 2017-12-05 16:33 |
| Reporter | Tann San | Assigned To | administrator | ||
| Priority | high | Severity | feature | Reproducibility | have not tried |
| Status | acknowledged | Resolution | open | ||
| Product Version | 5.0.0 | ||||
| Target Version | 7.0.x | Fixed in Version | |||
| Summary | 0000216: UTF8 support | ||||
| Description | SQL and HTML There is alot more to making the wiki fully UTF8 compatible, checkout this page on how Joomla does it all: http://joomla-wiki.de/doku.php?id=guidelines:utf-8 (unavailable) They state that they use the PHP mbstring extension for multibyte character handling, if the system does not detect that then it falls back on their own multibyte character handling class. We'd have to write our own version of that or find an opensource one we could use. To date I've never had a host with mbstring enabled. We would also have to add to the SQL updater code to triple the fields lengths in MySQL 4 and earlier databases. | ||||
| Steps To Reproduce | Steps: Convert to UTF-8 without BOM Using the open source phputf8 library to provide multibyte-aware versions of string functions (http://sourceforge.net/projects/phputf8). https://wackowiki.org/doc/Dev/Components/Lib/phputf8 | ||||
| Additional Information | Basically it's not such a quick job as I thought it was to begin with. Definitely put it off till the next version. http://wackowiki.sourceforge.net/unicode/HomePage | ||||
| Tags | No tags attached. | ||||
| related to | 0000163 | acknowledged | database language system | |
| related to | 0000424 | resolved | administrator | safehtml lib don't work propertly |
| related to | 0000130 | feedback | Always return iso-8859-1 | |
| related to | 0000336 | acknowledged | Have a base language file that the localisation ones can overwrite | |
| related to | 0000410 | resolved | Editor does not display cyrillic characters wysiwyg | |
| related to | 0000418 | resolved | administrator | creates a new page only with the default language |
| related to | 0000422 | resolved | administrator | patch for htmlspecialchars(), htmlentities(), html_entity_decode() |
| related to | 0000434 | resolved | administrator | Cyrillic letter encoding issue. |
| child of | 0000267 | acknowledged | add right-to-left support |
|
|
sets database and table encoding utf8 - DONE |
|
|
Unicode (UTF-8) with PHP 5.3, MySQL 5.5 and HTML5 Cheat Sheet -> with mbstring extention https://wackowiki.org/doc/Dev/Guidelines/UnicodeCheatSheet |
|
|
http://wiki.js.cnkk.org/HomePage https://gitorious.org/wackowiki-tchinese/wackowiki-unicode |
|
|
$string = iconv($source_codepage, 'UTF-8', $string) - get rid of mb-string issues if any (string length, case conversion, search etc) - create database with utf-8 charset and collation by default - make a migration path for the existing installations: * convert each and every db string from user-specified encoding to utf-8 * change DB encoding and collation to utf-8 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2008-08-10 19:34 | administrator | New Issue | |
| 2008-08-10 19:34 | administrator | Legacy | => NEW |
| 2008-08-10 19:37 | administrator | Reporter | administrator => Tann San |
| 2008-08-10 19:37 | administrator | Description Updated | |
| 2008-08-10 19:38 | administrator | Additional Information Updated | |
| 2008-08-10 19:38 | administrator | Status | new => acknowledged |
| 2008-08-10 19:39 | administrator | Relationship added | related to 0000163 |
| 2009-02-20 14:48 | administrator | Relationship added | child of 0000267 |
| 2009-04-13 11:26 | administrator | Relationship added | related to 0000130 |
| 2009-04-13 11:30 | administrator | Description Updated | |
| 2010-03-08 10:23 | administrator | Category | Unicode => unicode |
| 2011-06-17 16:20 | administrator | Note Added: 0000797 | |
| 2011-06-17 16:36 | administrator | Description Updated | View Revisions |
| 2011-06-17 16:47 | administrator | Note Added: 0000798 | |
| 2011-06-17 20:01 | administrator | Note Edited: 0000798 | View Revisions |
| 2011-07-30 07:01 | administrator | Relationship added | related to 0000336 |
| 2011-10-10 11:29 | administrator | Note Added: 0000822 | |
| 2011-10-10 12:31 | administrator | Note Edited: 0000798 | View Revisions |
| 2011-10-18 05:56 | administrator | Additional Information Updated | View Revisions |
| 2011-10-18 07:42 | administrator | Steps to Reproduce Updated | View Revisions |
| 2011-10-18 16:09 | administrator | Note Edited: 0000822 | View Revisions |
| 2011-10-18 16:09 | administrator | Note Edited: 0000822 | View Revisions |
| 2012-01-15 11:22 | administrator | Relationship added | related to 0000410 |
| 2012-01-15 13:09 | administrator | Note Edited: 0000798 | View Revisions |
| 2012-01-15 13:12 | administrator | Note Edited: 0000798 | View Revisions |
| 2012-04-09 09:16 | administrator | Steps to Reproduce Updated | View Revisions |
| 2012-04-11 11:02 | administrator | Steps to Reproduce Updated | View Revisions |
| 2012-06-14 04:01 | administrator | Relationship added | related to 0000418 |
| 2012-06-17 10:31 | administrator | Product Version | => 5.0.0 |
| 2012-06-17 10:31 | administrator | Description Updated | View Revisions |
| 2013-01-05 10:18 | administrator | Target Version | 5.4.0 => 7.0.x |
| 2013-03-05 08:47 | administrator | Relationship added | related to 0000424 |
| 2013-12-26 08:40 | administrator | Note Added: 0000908 | |
| 2013-12-26 08:47 | administrator | Note Edited: 0000908 | View Revisions |
| 2013-12-26 08:47 | administrator | Relationship added | related to 0000422 |
| 2013-12-26 08:58 | administrator | Assigned To | => administrator |
| 2013-12-26 08:58 | administrator | Priority | normal => high |
| 2014-01-06 12:13 | administrator | Relationship added | related to 0000434 |
| 2017-12-05 16:31 | administrator | Steps to Reproduce Updated | View Revisions |
| 2017-12-05 16:33 | administrator | Note Edited: 0000798 | View Revisions |
