Illegal mix of collations (utf8_general_ci,IMPLICIT) and

--001636457b26a9b91504795bc136
Content-Type: text/plain; charset=ISO-8859-1

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.

--001636457b26a9b91504795bc136--