about rebuild mysql for support 'gbk_chinese_ci'

[huming17]

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 !

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

[huming17]

(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

[RatS]

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