Hi Guy`s! Today i hacked MySql but hove some trouble.
i have two tables (lentas and categories_documents) i try join them: SELECT `lentas`.* FROM `lentas` left join categories_documents As cd ON(cd.document_id = lentas.document_id AND cd.document_type = lentas.document_type) WHERE (cd.category_id = 1); mysql> show table status like '%categories_documents%'\G *************************** 1. row *************************** Name: categories_documents Engine: InnoDB Version: 10 Row_format: Compact Rows: 12391 Avg_row_length: 128 Data_length: 1589248 Max_data_length: 0 Index_length: 1589248 Data_free: 4194304 Auto_increment: 12746 Create_time: 2009-11-27 17:46:36 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: mysql> show table status like '%lentas%'\G *************************** 1. row *************************** Name: lentas Engine: InnoDB Version: 10 Row_format: Compact Rows: 12611 Avg_row_length: 126 Data_length: 1589248 Max_data_length: 0 Index_length: 507904 Data_free: 4194304 Auto_increment: 11895 Create_time: 2009-11-27 17:55:45 Update_time: NULL Check_time: NULL Collation: utf8_unicode_ci Checksum: NULL Create_options: Comment: But BUM faqen MYSQL sad ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' I fly on Mac OS 10.5 MySql 5.4.3-beta on Linux it work allrigth! Please help. Thanks.