[development] ALL Contrib maintainers: UTF-8 update

Khalid B kb at 2bits.com
Sat Jan 21 17:36:37 UTC 2006


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 at 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
>


More information about the development mailing list