Problem with default-collation

2005-03-17 Thread Dana Sharvit - M
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

Re: Problem with default-collation

2005-03-17 Thread Gabriel PREDA
H... It looks like you upgraded from a MySQL that doesn't know about collations... All the tables created with a version of MySQL that doesn't know about collation are considered by a version that does know... being of collation latin1_swedish_ci... (on columns where collation makes sense...