Khalid B wrote:
In order to solve this, you either have to run the update for the specific module, or you can do it manually for every table like so:
ALTER TABLE vocabulary_node_types CONVERT TO CHARACTER SET utf8;
That takes care of the illegal mix of collations errors.
On 1/21/06, Khalid B <kb@2bits.com> wrote:
I am also getting these errors now:
Warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT * FROM access WHERE status = 1 AND type = 'host' AND LOWER('192.168.0.2') LIKE LOWER(mask) in .../includes/database.mysql.inc on line 118
You just have to scroll down the page and continue with the update. This is a warning, thats all. No need to do anything manually. I already posted about this in this thread.