Hello!

I'm having some trouble reading the fields "subject" and "from_addr" from
msgs table, they are in latin1 encoding, I need them in UTF8.

The only way I'm able to do this is to issue an update to the msgs table
preceded by a "set names utf8":

<code>
$conn_h->execute("set names utf8");
$conn_h->execute($upd_msg2, $from, $subj, $mail_id);
$conn_h->execute("set names latin1");
</code>
I've tested this code, and works fine with my web gui.

$upd_msg2 only updates the 2 fields i want.

Is there another way to do this?
Will this break amavis ?
Should I create 2 new fields to store the utf8 version of these two fields?

Thanks in advance, Miguel Fernandes.



------------------------------------------------------------------------------
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
 AMaViS-HowTos:http://www.amavis.org/howto/ 

Reply via email to