+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: about rebuild mysql for support 'gbk_chinese_ci' (/thread-10622.html)
about rebuild mysql for support 'gbk_chinese_ci' - huming17 - 05-06-2010 11:01 PM
about rebuild mysql for support 'gbk_chinese_ci';
i am install the ispcp follow the document at the freebsd;
but the mysql could not support 'gbk_chinese_ci';
error info "Unknown collation 'gbk_chinese_ci' in table";
how could i rebuild or install just mysql to support the 'gbk_chinese_ci';
Thanks !
RE: about rebuild mysql for support 'gbk_chinese_ci' - huming17 - 05-07-2010 02:28 AM
(05-06-2010 11:01 PM)huming17 Wrote: about rebuild mysql for support 'gbk_chinese_ci';
i am install the ispcp follow the document at the freebsd;
but the mysql could not support 'gbk_chinese_ci';
error info "Unknown collation 'gbk_chinese_ci' in table";
how could i rebuild or install just mysql to support the 'gbk_chinese_ci';
Thanks !
someone says use this way
/*
cd /usr/ports/databases/mysql51-server
make WITH_CHARSET=gbk WITH_XCHARSET=all WITH_COLLATION=gbk_chinese_ci BUILD_STATIC=yes install clean
*/
but i am afraid , if i execute it will make some effects to ispcp
someone have any suggest?
RE: about rebuild mysql for support 'gbk_chinese_ci' - huming17 - 05-15-2010 04:10 PM
(05-07-2010 02:28 AM)huming17 Wrote:(05-06-2010 11:01 PM)huming17 Wrote: about rebuild mysql for support 'gbk_chinese_ci';
i am install the ispcp follow the document at the freebsd;
but the mysql could not support 'gbk_chinese_ci';
error info "Unknown collation 'gbk_chinese_ci' in table";
how could i rebuild or install just mysql to support the 'gbk_chinese_ci';
Thanks !
someone says use this way
/*
cd /usr/ports/databases/mysql51-server
make WITH_CHARSET=gbk WITH_XCHARSET=all WITH_COLLATION=gbk_chinese_ci BUILD_STATIC=yes install clean
*/
but i am afraid , if i execute it will make some effects to ispcp
someone have any suggest?
At last solved by
cd /usr/ports/databases/mysql50-server
make WITH_CHARSET=gbk WITH_XCHARSET=all WITH_COLLATION=gbk_chinese_ci BUILD_STATIC=yes install clean
RE: about rebuild mysql for support 'gbk_chinese_ci' - RatS - 05-15-2010 06:01 PM
you just need to make sure that the ispcp Tables are UTF-8. As long as you are not changing its charset nothing will happen to ispcp