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 [email protected] 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
