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.

Reply via email to