8 messages in com.mysql.lists.eventum-usersRe: Swedish characters in email
FromSent OnAttachments
Joc...@ Mailinglist07 Nov 2007 23:03 
Joc...@ Mailinglist12 Nov 2007 22:28 
Bryan Alsdorf12 Nov 2007 22:41 
Joc...@ Mailinglist13 Nov 2007 11:50 
Jostein Martinsen13 Nov 2007 12:04 
Bryan Alsdorf13 Nov 2007 12:13 
Joc...@ Mailinglist13 Nov 2007 12:54 
Joc...@ Mailinglist13 Nov 2007 12:59 
Subject:Re: Swedish characters in email
From:Bryan Alsdorf (bry@mysql.com)
Date:11/13/2007 12:13:15 PM
List:com.mysql.lists.eventum-users

Hi Jocke,

Jocke @ Mailinglist wrote: <snip>

The data in MySQL is (through phpMyAdmin)

For one entered via WebUI

------------------------- Test2 åäö ÅÄÖ

------------------------- This shown correctly in WebUI and in emails

For one entered via email "gateway"

------------------------- Test åäö ÅÄÖ

------------------------- This is NOT shown correctly in WebUI or in emails

The output of "show variables like '%character%';"

Variable_name Value character_set_client utf8 character_set_connection utf8 character_set_database latin1 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/

I suspect it could be something with unicode encoding, or?!

Yes, definitely has to do with unicode encoding. I suspect PHP running from the web interface is connecting using one charset while the cron to download email is using another charset.

To force Eventum to always use UTF-8 for its connection to the database, open up include/class.db_api.php and add the following line to the end of the constructor (line 75 in my dev version):

$this->dbh->query("SET NAMES utf8");

This is what I am doing internally to make sure everything is consistent. If this works for you I will add it into a future version of Eventum.

Best Regards,

-- Bryan Alsdorf, Manager of Support Systems MySQL AB, www.mysql.com

Discover new MySQL Monitoring & Advisory features at: http://www.mysql.com/products/enterprise/whats_new.html