[Obm] set names required for sql connection

[Vincent Régnard]

Hi all,

We noticed that using obm on mysql servers where the default charset is 
different from that used for obm database, the storage is invalid.
There seams to be missing a sql "SET NAMES connectioncharset" just after 
connection to the sql server is achieved.

Here we have a mysql server using default charset to latin1. Our obm 
database (and tables) use charset utf8.

We had to add

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

in DB_Sq::Connect() to have it work properly.

Maybe that could be a global setting in the configuration file ?

NB: at first sight, probleme is not visible in the web front-end. You 
realy have to look at the database storage to see the problem.

Hope that helps.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5471 bytes
Desc: S/MIME Cryptographic Signature
Url : http://www.list.aliasource.fr/pipermail/obm/attachments/20071220/76c405b4/smime.bin