472,958 Members | 2,442 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

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

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
0 3854

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Alex Sarafian | last post by:
Hello I have build an application with php/mysql on my localhost Windows XP (english) My application lets you select the language which at the moment is Greek and English. My application is...
4
by: Ka | last post by:
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...
0
by: Primaria Falticeni | last post by:
Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List
9
by: Nick | last post by:
I have the following code, and it works well on Mozilla 1.6. (However, the image src property cannot be set on Mozilla 1.2.1). Unfortunately, all the code: document.images.itemImage.src =...
2
by: Kajol | last post by:
Hi All, I am using server version: 4.1.11-nt on windows 2000. I want to create a table with ID as auto increment and initialise it with a starting value of 1000. I am trying to do following...
3
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - I have window.status="Moomin"; why doesn't the statusbar change?...
11
by: cybervigilante | last post by:
I can't seem to change the include path on my local winmachine no matter what I do. It comes up as includ_path .;C:\php5\pear in phpinfo() but there is no such file. I installed the WAMP package...
0
by: cappa | last post by:
hi, i've some problem to print to screen and save date in mysql if the entries contain char like ,... i try to read some post but i'm not able to solve my problem. i use easyphp 1.8 with...
2
by: malcster2 | last post by:
hello, i am a beginner to ajax. i have created a mysql database, which i would like to access from a web page. i have created 3 files, a html to display the data, a php file to extract the data,...
6
by: gavy7210 | last post by:
hello i am using struts 1.2,Eclipse Platform Version: 3.4.2,mySql 5.0.1,jdk 1.5.. i have a login form(jsp) in which a user logs in,in case he doesnt enter his username and/or password an error...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.