By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,276 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,276 IT Pros & Developers. It's quick & easy.

how to change the default charset with GBK or other language of mysql ??

P: n/a
Ka
I install a mysql server in default installation with latin charset, but
I want to use GBK(a chinese charset), so that I can store and
search chinese words directly.

so, I download, unpack and then rewrite the mysql.spec and then recompile
the
package mysql-3.23.56-1.80.src.rpm.

first, this file contains some files:
[root@a root]# rpm2cpio mysql-3.23.56-1.80.src.rpm |cpio -t
filter-requires-mysql.sh
my.cnf
mysql-3.23.51-manfixes.patch
mysql-3.23.56.tar.gz
mysql-errno.patch
mysql.init
mysql.logrotate
mysql.spec

so, I rewrite the mysql.spec with
../configure \
--with-charset=gbk\
.......

and then cp all file into /usr/src/redhat/SOURCES/
#rpmbuild -ba /usr/src/redhat/SOURCES/mysql.spec

all compile is okay,
but the binary test can not be passed, why ? does it fail in charset=gbk???
and following is the part of output :

+ make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
030727 19:29:53 ../sql/mysqld: Shutdown Complete

Installing Slave Databases
030727 19:29:53 ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------------------
alias 0.10 0.09 0.46 [ pass ]
alter_table 0.03 0.03 0.18 [ pass ]
analyse 0.03 0.03 0.06 [ pass ]
auto_increment 0.01 0.05 0.12 [ pass ]
backup 0.04 0.02 0.12 [ pass ]
bdb-alter-table-1 0.03 0.02 3.08 [ pass ]
bdb-alter-table-2 0.04 0.01 0.06 [ pass ]
bdb-crash 0.04 0.04 0.36 [ pass ]
bdb-deadlock 0.04 0.02 0.35 [ pass ]
bdb 0.02 0.07 9.83 [ pass ]
bench_count_distinct 0.04 0.04 0.13 [ pass ]
bigint 0.03 0.03 0.10 [ pass ]
binary .... .... .... [ fail ]
Error at line 44: Result length mismatch <<Below are the diffs between

actual and expected results:
-------------------------------------------------------
*** r/binary.result Thu Mar 13 21:46:29 2003
--- r/binary.reject Sun Jul 27 19:30:25 2003
***************
*** 1,13 ****
name
- ?
?
?
concat("*",name,"*")
- *?*
*?*
*?*
min(name) min(concat("*",name,"*")) max(name)
max(concat("*",name,"*"))
! ? *?* ? *?*
name
?
?
--- 1,13 ----
name
?
+ ?
?
concat("*",name,"*")
*?*
+ *?*
*?*
min(name) min(concat("*",name,"*")) max(name)
max(concat("*",name,"*"))
! ? *?* ? *?*
name
?
?
***************
*** 19,26 ****
min(name) min(concat("*",name,"*")) max(name)
max(concat("*",name,"*"))
? *?* ? *?*
name
- ?
- ?
name
?
?
--- 19,24 ----
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporti...test_bugs.html
to find the reason to this problem and how to report this.

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1
error: Bad exit status from /var/tmp/rpm-tmp.75496 (%build)
RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.75496 (%build)
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.