Re: illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation=

2005-01-25 Thread Santino
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

Re: illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation=

2005-01-25 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html Cecep Rosuludin [EMAIL PROTECTED] wrote: Dear All, I found an error in mysql message, when I tried to excute this sql in mysql= front: select

illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation=

2005-01-24 Thread Cecep Rosuludin
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