Re: illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation=
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 + 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]
Re: illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation=
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.voy_aims,voyage.td, poo.loading_port_name,pod.disch_name from dsr2 left join voyage on voyage.voy=3Ddsr2.mother_vessel_voy left join poo on poo.loading_port=3Ddsr2.pol left join pod on pod.disch_code=3Ddsr2.pod the error message is : illegal mix of collation(latin2_general_ci Implicit)and(latin1_swedish_ci I= MPLICIT) for operation=3D please advice regarding this error,...how to solve this problem..! --=20 ___ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as= p?SRC=3Dlycos10 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
illegal mix of collations(latin2_general_ci Implicit)and(latin1_s wedish_ci IMPLICIT) for operation=
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]