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]