Hello, I think your tables have a collation different from the connection collation.
Open mysql client:
mysql> show variables like 'colla%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.04 sec)
and if are different set the collation in your my.cnf file. Santino
At 1:25 +0000 25-01-2005, Cecep Rosuludin wrote:
Dear All,
I found an error in mysql message, when I tried to excute this sql in mysqlfront:
select dsr2.mother_vessel,mother_vessel_voy,voyage.voy_aims,voyage.td, poo.loading_port_name,pod.disch_name from dsr2 left join voyage on voyage.voy=dsr2.mother_vessel_voy left join poo on poo.loading_port=dsr2.pol left join pod on pod.disch_code=dsr2.pod
the error message is :
illegal mix of collation(latin2_general_ci Implicit)and(latin1_swedish_ci IMPLICIT) for operation"="
please advice regarding this error,...how to solve this problem..! -- _______________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
