mysql - illegal mix of collations

[Zuzana Fuksová]

a)
http://dev.mysql.com/doc/mysql/en/Charset-database.html
show create database jmeno; napovi

b)
v konkretni query pouzit toto
http://dev.mysql.com/doc/mysql/en/Charset-CONVERT.html

Z


JS> Zdar,

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

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

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

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

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

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

JS> Mam 

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

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

JS> 	Diky

JS> 		js