Naomi Carson wrote: > Hi there, > > Since upgrading to dbmail 2.2.7 from 2.2.5, we've been having problems > with emails with latin1 characters such as é (e with accent accute) in > the subject line. Other non-ascii characters such as Arabic or Thai > seem to work fine. > > Before I try to store the message in dbmail, a subject line of "ééé" is > encoded to "=?utf-8?b?w6nDqcOp?=". > > When I try to store the message, I get the following error: > > Error:[sql] dbpgsql.c,db_query(+287): query failed [INSERT INTO > dbmail_subjectfield (physmessage_id, subjectfield) VALUES (60,'ééé')] : > [ERROR: invalid byte sequence for encoding "UTF8": 0xe9e9e9 HINT: This > error can also happen if the byte sequence does not match the encoding > expected by the server, which is controlled by "client_encoding". ] > > I was able to store this subject no problem using dbmail 2.2.5. Any ideas?
The 'encoding' parameter in dbmail.conf needs to be the same as the encoding in your database. So if you created your database with: createdb -E latin-1 dbmail then the 'encoding' specified in dbmail.conf must also be 'latin-1' (or iso-8859-1, which is the same). The default dbmail.conf uses 'encoding = utf8'. But you must only use utf8 in the encoding parameter if your database was also created with utf8 encoding (createdb -E utf8 dbmail). -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
