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]
