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