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 dsr2.mother_vessel,mother_vessel_voy,voyage.v

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

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 poo.loading_por