Hi,

I have tried to select data from more tables using union, but it gaves the following error:

ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION'

I have verified the tables (using show create table table_name) and all of them are:
engine=InnoDB default charset=utf8

and there are no fields with another charset.

The same database works under Windows, but it gives that error under Linux.

Please tell me what can I do to make it work.

Thank you.

Octavian


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to