about rebuild mysql for support 'gbk_chinese_ci'

[huming17]

(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?