My environment
mySQLCC 0.9.4 beta
Tomcat 5.0.28
mysql-connector-java-3.0.15-ga-bin.jar release
MySQL 4.1.5
j2sdk1.4.2_05
I always have "Illegal mix of collations" error
This is the detail
[db] ERROR 1267: Illegal mix of collations (big5_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
I am in Taiwan
So I use Big5 encode
The error means big5 and latin encode can't use '=' to assign
So I have to change MySQL default-character-set into big5 encode
detail from this teaching
http://mysql.netvisao.pt/doc/mysql/en/Charset-examples.html
I see the MySQL default encode is
character_set_client = latin1
character_set_connection = latin1
character_set_database= latin1
character_set_result= latin1
character_set_server= latin1
character_set_system= latin1
colloation_connection= latin1_swedish_ci
colloation_database= latin1_swedish_
cicolloation_server= latin1_swedish_ci
and when I execute"mysqld --default-character-set=big5" in DOS-mode
(the commands line stops and no response )
but MySQL default encode changes
character_set_client = latin1
character_set_connection = latin1
character_set_database= big5
character_set_result= latin1
character_set_server=big5
character_set_system= latin1
colloation_connection= latin1_swedish_ci
colloation_database= big5_chinese_
cicolloation_server=big5_chinese_ci
Finally the "Illegal mix of collations" error is solved
But when I restart the mySQL
all the encode changes back to latins....
why??
How to solve this error......
thx....