| Main Archive Page > Month Archives > amavis-user archives |
Re: [AMaViS-user] Incorrect utf8 subject stored in MySQL
From: Zhang Huangbin <zhbmaillistonly_at_nospam>Date: Tue Aug 17 2010 - 02:07:58 GMT
To: Mark Martinec <Mark.Martinec+amavis@ijs.si>
On Aug 17, 2010, at 3:14 AM, Mark Martinec wrote:
> The msgs.subject string you show looks about right, assuming the
> cut/paste/wrapping problem in your =E4=B8 =E6=96=87=E6= =B5=8B=E8=AF.
>
> The actual UTF-8 encoded string resulting from
> =?UTF-8?B?5Lit5paH5rWL6K+V?=
> should be (in hex):
> e4 b8 ad e6 96 87 e6 b5 8b e8 af 95
I edit "msgs.subject" with phpMyAdmin directly, set a new value with Chinese characters, it works. But value inserted by Amavisd is still incorrect.
> Perhaps your MySQL client/server/results settings and resulting conversions
> are getting in the way. Try:
>
> SHOW VARIABLES LIKE 'character_set%';
Result:
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
> You may try experimenting with client or server settings, perhaps:
>
> SET character_set_results = 'utf8';
>
> or perhaps adding to my.cnf:
>
> [mysql]
> default-character-set=utf8
Already have this lin my.cnf:
[client]
default-character-set=utf8
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
Please visit http://www.ijs.si/software/amavisd/ regularly
For administrativa requests please send email to rainer at openantivirus dot org