mysql - illegal mix of collations

Jan Stary hans at stare.cz
Fri Aug 13 17:28:57 CEST 2004


Zdar,

nainstaloval jsem si /usr/ports/databases/mysql41-server
(make WITH_CHARSET=latin1 WITH_XCHARSET=all WITH_OPENSSL=yes OVERWRITE_DB=yes
 BUILD_OPTIMIZED=yes install)

a pri poinstalacni krocich (zruseni anonymniho pristupu, heslo rpo roota)
dostavam vytrvalou hlasku

hans at ns$ mysql -u root mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.3-beta-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> delete from user where user = '';
ERROR 1267 (HY000): Illegal mix of collations (latin2_bin,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation '='

Cim to muze byt? Na /etc/my.cnf jsem nesahnul.

Mam 

declare -x LANG="cs_CZ.ISO8859-2"
declare -x LANGUAGE="cs_CZ.ISO8859-2"
declare -x LC_COLLATE="cs_CZ.ISO8859-2"
declare -x LC_CTYPE="cs_CZ.ISO8859-2"
declare -x LC_MESSAGES="C"
declare -x LC_MONETARY="cs_CZ.ISO8859-2"
declare -x LC_NUMERIC="cs_CZ.ISO8859-2"
declare -x LC_TIME="C"

takze jsem provedl export LC_ALL=C, a dopadnu stejne.
Odkud vzal to latin2_bin a latin1_swedish?

	Diky

		js




More information about the Users-l mailing list