hello All, can anybody tell me how to correct this problem:
1. I use queries like that: select /*! SQL_BUFFER_RESULT */ klient.logo, klient.klientid, klient.klientnazwa, klient.struktura, concat(kodpocztowy,' ',miejscowosc) miasto, aparatnumer, concat(ulicaskrot,' ',ulicanazwa,' ',posesja) ulica,concat('woj. ',wojewodztwo,', powiat: ',powiat, ', gmina: ', gmina) wojpow, klientbranze branza, email, www, wizytowka from klient [where conditions or no conditions] 2. we upgraded PHP to 5.0.3, installed Zend Optimizer and upgraded MySQL from 4.0.20 to 4.1.7 3. after upgrading when I try to execute query from [1.] I have error: MySQL Error: 1270 (Illegal mix of collations (latin2_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin2_general_ci,IMPLICIT) for operation 'concat') Session halted. 4. system variables are like this: variable session global back log 50 50 basedir /usr/local/mysql/ /usr/local/mysql/ binlog cache size 32768 32768 bulk insert buffer size 8388608 8388608 character set client latin1 latin2 character set connection latin1 latin2 character set database latin2 latin2 character set results latin1 latin2 character set server latin2 latin2 character set system utf8 utf8 character sets dir /usr/local/mysql/share/mysql/charsets/ /usr/local/mysql/share/mysql/charsets/ collation connection latin1_swedish_ci latin2_general_ci collation database latin2_general_ci latin2_general_ci collation server latin2_general_ci latin2_general_ci how to proper correct that? best regards in advance Darek -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004-12-17 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]