Hi, I am using mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686) When running a certain query I get the following error: DBD::mysql: t execute failed: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set' I do not understand why I have a mix of collations since in the my.cnf I indicate: [mysqld] default-character-set = utf8 default-collation = utf8_general_ci Where is the latin1_swedish_ci coming from? why isn't default-collation overwriting it? Appreciate any help.
Thanks Dana -------------------------------------------------------- This message has been scanned for viruses and dangerous content by Ex Libris Ltd, and is believed to be clean. --------------------------------------------------------