To have support for Chinese in UTF-8, make sure that the database is setup correctly for UTF-8 support. If DB is already created, you can alter the database / table collation which will fix Chinese support.
Currently I have not yet got osTicket to work with GB2312 or GBK e-mails, however i'm working on it. Nonetheless, I prefer and would recommend UTF8 anyways (but obviously cannot control external users who may send mail to the ticketing system with their default language).
首先建立数据库需要指定正确的语言。由于 osTicket 系统都是使用 UTF-8 我会建议继续使用 UTF-8 放气国标,但可需要改库和表格结构。
数据库建立之后可在 mysql console 执行一下命令指定 utf-8:
ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
然后执行 osTicket setup 之前把 setup/osticket.sql 所有 ENGINE=MyISAM 改为 ENGINE=MyISAM DEFAULT CHARSET=utf8 才通过 setup 建立表格。
或者如已经完成安装也可在 mysql console 针对每一个表格执行一下命令:
ALTER TABLE CONVERT TO CHARACTER SET utf8;
... 之后就能发和接受 utf8 中文邮件,也能通过 osTicket 系统查看和开请求。
GB2312 或 GBK 支持看来需要改代码,正在调查中....