6.0.0-beta1
7/6/25

[#1924] charset problem
Summary charset problem
Queue Wicked
Type Bug
State Resolved
Priority 2. Medium
Owners Horde Developers (at) , jan (at) horde (dot) org
Requester david (at) tmv (dot) gov (dot) tw
Created 05/07/2005 (7365 days ago)
Due
Updated 10/01/2010 (5392 days ago)
Assigned 05/30/2005 (7342 days ago)
Resolved 05/30/2005 (7342 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
06/01/2005 05:18:22 AM Chuck Hagenbuch Comment #9 Reply to this comment
Committed, thanks.
06/01/2005 01:30:24 AM david (at) tmv (dot) gov (dot) tw Comment #8
New Attachment: sql.php.patch Download
Reply to this comment
change_log field also requird multibyte support,patch was attached.



David
05/30/2005 09:33:50 AM Jan Schneider Comment #7
State ⇒ Resolved
Reply to this comment
Wicked should have full charset support now, but requires a (not yet 
released) Text_Wiki version greater than 1.0.0. There is currently no 
way to have non-ascii page names though, because Text_Wiki requires a 
regular expression that expresses a wiki word to detect and correctly 
link them. And this is not possible in languages that don't have a 
concept of upper case and lower case at the moment.
05/30/2005 08:30:15 AM Jan Schneider Comment #6
State ⇒ Assigned
Reply to this comment
Looks like charset support has been added to Text_Wiki after 1.0.0, 
looking into it.
05/30/2005 04:33:20 AM Chuck Hagenbuch Comment #5
State ⇒ Stalled
Reply to this comment
Stalling this; any reason not to close it and open a Text_Wiki bug instead?
05/25/2005 02:44:47 PM Jan Schneider Comment #4
State ⇒ Feedback
Reply to this comment
As far as I can see, saving and retrieving multibyte texts works fine. 
The problem is that Text_Wiki that we use for the wiki markup parsing 
and rendering doesn't support multibyte at all and messes up some 
things like wiki links.
05/07/2005 08:38:22 AM Jan Schneider State ⇒ Assigned
Assigned to Horde DevelopersHorde Developers
Assigned to Jan Schneider
 
05/07/2005 04:43:38 AM david (at) tmv (dot) gov (dot) tw Comment #3 Reply to this comment
Hi chuck:

Thanks for your reply.

Chinese string couldn't work both for page name & page text.



And i am curious why  wiki only support unicode backend for multi-byte 
cahrset ?
05/07/2005 04:31:12 AM Chuck Hagenbuch Comment #2
State ⇒ Feedback
Reply to this comment
Please be a little more specific than "seems not to". Is the problem 
in the page name? The page text? Both? What *exactly* is the problem?
05/07/2005 04:14:06 AM david (at) tmv (dot) gov (dot) tw Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ charset problem
Queue ⇒ Wicked
State ⇒ Unconfirmed
Reply to this comment
Chinese seems not work or display correctly in wicked,even used 
unicode backend.



  I used create_database.sql to create a unicode charset database in   
mysql server  for wicked use.

#more create_database.sql

CREATE DATABASE `wiki3` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

#mysql wiki3<wicked.sql



And here are my wicked's conf.php:

      .

      .

$conf['wicked']['diff_format'] = 'unified';

$conf['wicked']['require_change_log'] = false;

$conf['menu']['pages'] = array ('WikiHome', 'HowToUseWiki', 
'RecentChanges', 'TitleSearch', 'AllPages');

$conf['menu']['apps'] = array();

$conf['storage']['driver'] = 'sql';

$conf['storage']['params']['persistent'] = true;

$conf['storage']['params']['hostspec'] = 'localhost';

$conf['storage']['params']['username'] = 'user';

$conf['storage']['params']['password'] = 'password';

$conf['storage']['params']['port'] = 3306;

$conf['storage']['params']['protocol'] = 'tcp';

$conf['storage']['params']['database'] = 'wiki3';

$conf['storage']['params']['charset'] = 'utf-8';

$conf['storage']['params']['phptype'] = 'mysql';

$conf['storage']['params']['table'] = 'wicked_pages';

$conf['storage']['params']['historytable'] = 'wicked_history';

$conf['storage']['params']['attachmenttable'] = 'wicked_attachments';

$conf['storage']['params']['attachmenthistorytable'] =

wicked_attachment_history';

$conf['storage']['params']['driverconfig'] = 'custom';



And here is horde/config/conf.php

    .

    .

   .

$conf['sql']['database'] = 'horde3';

$conf['sql']['charset'] = 'big-5';

$conf['sql']['phptype'] = 'mysql';



David Chang


Saved Queries