[°ÝÃD°lÂÜ #1924] NEW: charset problem

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=1924
-----------------------------------------------------------------------
 Ticket             | 1924
 Created By         | david at tmv.gov.tw
 Summary            | charset problem
 Queue              | Wicked
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


david at tmv.gov.tw (2005-05-06 21:14) wrote:

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