I installed webform, and those were the only tables in my drupal database that weren't using the utf8 charset.

Perhaps you can add something like

"CHARACTER SET utf8
COLLATE utf8_general_ci"

to the end of your install queries?

Thanks.

CommentFileSizeAuthor
#1 webform.mysql1.58 KBMartin Haanz
webform.install8.01 KBMartin Haanz

Comments

Martin Haanz’s picture

StatusFileSize
new1.58 KB

Here's another attachment with my revisions.

quicksketch’s picture

Assigned: Unassigned » quicksketch
Status: Active » Fixed

Thanks for the post.

Instead of modifying the .install file as you suggested, I ran _system_update_utf8 instead in an update to the webform database schema. I modeled this after the views.install file. I assume you've already fixed your tables, but other users can simply download the new install file and run update.php.

The COLLATE command wasn't working on my installation of mySQL (4.0.25), so I ommitted it from the mySQL file. Hopefully no one will be using this file anyway.

Anonymous’s picture

Status: Fixed » Closed (fixed)