After enabling and configuring this great module, I get the following error:

user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT name FROM title_rewrite WHERE id != 1 AND name = 'עמודי מוצר' in /home/.../uber/includes/database.mysql.inc on line 172

And then all fields include '???? ????' insted of the correct hebrew text.
Just for referrence - i have no 'latin1_swedish_co' as far as i know...

Comments

Anonymous’s picture

Anonymous (not verified) commented

The default collation for MySQL is latin1_swedish_co. If you don't specify a different one when you create your database, that's the one you get.

I am investigating how best to address this.

The install can be fixed by adding this to the create table statement:
/*!40100 DEFAULT CHARACTER SET UTF8 */
This is how the locale module creates its tables.

But that only fixes new installations. I believe I can create an update implementation that performs an alter table to change the character set to UTF8 and the collation to utf8_general_ci.

Anonymous’s picture

Anonymous (not verified) commented
Version: 5.x-1.0 » 5.x-1.2
Assigned: Unassigned »
Status: Active » Fixed

I've added an update hook in the install file that should correct the problem if you run update.php

The install hook also specifies UTF8 explicitly for the character set.

This is in the 5.x-1.2 release.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.