<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=Big5" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> Hello, I have just tried to update /etc/my.cnf... and restart MySQL Server. But it is still the problem, because we are using big5 code... Edward. Ed Greshko wrote: <blockquote cite="mid4614D721.9030905@greshko.com" type="cite"> <blockquote type="cite"> <pre wrap="">How to change the Character Set and the Collation from default ( utf8 ) to big5 ? </pre> </blockquote> <pre wrap=""> <a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html">http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html</a> </pre> <blockquote type="cite"> <pre wrap="">-------- Original Message -------- Subject: [turba] Character Set with MySQL ( DB ) Date: Thu, 05 Apr 2007 15:54:45 +0800 From: <a class="moz-txt-link-abbreviated" href="mailto:edwardspl@ita.org.mo">edwardspl@ita.org.mo</a> To: IMP <a class="moz-txt-link-rfc2396E" href="mailto:imp@lists.horde.org"><imp@lists.horde.org></a> CC: <a class="moz-txt-link-abbreviated" href="mailto:turba@lists.horde.org">turba@lists.horde.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:turba@lists.horde.org"><turba@lists.horde.org></a> Dear All, After install and config the turba package with IMP... The is a problem about the Character Set ( Collation ) with DB Server ( MySQL )... So, which php files ( config ) need to be the following : SET NAMES 'big5'; PS : Due to the default collation from the MySQL ( DB Server ) is using utf8. Edward. -- Turba mailing list - Join the hunt: <a class="moz-txt-link-freetext" href="http://horde.org/bounties/#turba">http://horde.org/bounties/#turba</a> Frequently Asked Questions: <a class="moz-txt-link-freetext" href="http://horde.org/faq/">http://horde.org/faq/</a> To unsubscribe, mail: <a class="moz-txt-link-abbreviated" href="mailto:turba-unsubscribe@lists.horde.org">turba-unsubscribe@lists.horde.org</a> -- Turba mailing list - Join the hunt: <a class="moz-txt-link-freetext" href="http://horde.org/bounties/#turba">http://horde.org/bounties/#turba</a> Frequently Asked Questions: <a class="moz-txt-link-freetext" href="http://horde.org/faq/">http://horde.org/faq/</a> To unsubscribe, mail: <a class="moz-txt-link-abbreviated" href="mailto:turba-unsubscribe@lists.horde.org">turba-unsubscribe@lists.horde.org</a> </pre> </blockquote> <pre wrap=""> </pre> </blockquote> </body> </html>