Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

utf8 errors again/still

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


michael.monnerie at it-management

Apr 9, 2008, 2:55 AM

Post #1 of 3 (255 views)
Permalink
utf8 errors again/still

Error:[sql] dbpgsql.c,db_query(+287): query failed [.INSERT INTO
dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES
(9,1194586,'Schlumpf hat dich als FreundIn auf Facebook hinzugef303
274gt...')] :[.FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«:
0xc320 HINT: Dieser Fehler kann auch auftreten, wenn die Bytesequenz
nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche
durch »client_encoding« bestimmt wird. ]

On Apr 8, I got this log entry in dbmail. How can it be that still there
are UTF8 errors? My DB is UTF8, client_encoding also. How could I
prevent this?

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net Key-ID: 1C1209B4
Attachments: signature.asc (0.19 KB)


michael.monnerie at it-management

Apr 9, 2008, 2:28 PM

Post #2 of 3 (235 views)
Permalink
Re: utf8 errors again/still [In reply to]

On Mittwoch, 9. April 2008 Michael Monnerie wrote:
> Error:[sql] dbpgsql.c,db_query(+287): query failed [.INSERT INTO
> dbmail_headervalue (headername_id, physmessage_id, headervalue)
> VALUES (9,1194586,'Schlumpf hat dich als FreundIn auf Facebook
> hinzugef303 274gt...')] :[.FEHLER: ungültige Byte-Sequenz für
> Kodierung »UTF8«: 0xc320 HINT: Dieser Fehler kann auch auftreten,
> wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der
> Server erwartet, welche durch »client_encoding« bestimmt wird. ]
>
> On Apr 8, I got this log entry in dbmail. How can it be that still
> there are UTF8 errors? My DB is UTF8, client_encoding also. How could
> I prevent this?

I hope the discussion of lost cache entries doesn't make this issue
lost. How could I prevent such problems? It looks like here I'm really
loosing e-mail, as the headervalue has incorrect coding. Probably the
e-mail itself can't be inserted too?

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net Key-ID: 1C1209B4
Attachments: signature.asc (0.19 KB)


paul at nfg

Apr 10, 2008, 12:27 AM

Post #3 of 3 (230 views)
Permalink
Re: utf8 errors again/still [In reply to]

Michael Monnerie wrote:
> On Mittwoch, 9. April 2008 Michael Monnerie wrote:
>> Error:[sql] dbpgsql.c,db_query(+287): query failed [.INSERT INTO
>> dbmail_headervalue (headername_id, physmessage_id, headervalue)
>> VALUES (9,1194586,'Schlumpf hat dich als FreundIn auf Facebook
>> hinzugef303 274gt...')] :[.FEHLER: ungültige Byte-Sequenz für
>> Kodierung »UTF8«: 0xc320 HINT: Dieser Fehler kann auch auftreten,
>> wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der
>> Server erwartet, welche durch »client_encoding« bestimmt wird. ]
>>
>> On Apr 8, I got this log entry in dbmail. How can it be that still
>> there are UTF8 errors? My DB is UTF8, client_encoding also. How could
>> I prevent this?
>
> I hope the discussion of lost cache entries doesn't make this issue
> lost. How could I prevent such problems? It looks like here I'm really
> loosing e-mail, as the headervalue has incorrect coding. Probably the
> e-mail itself can't be inserted too?

Email insertion is *not* charset dependent. Mail blobs are stored as-is and do
not require the charset voodoo that the header caching does require.

Please test the attached patch.

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
Attachments: patch_dbmail-message.diff (0.89 KB)

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.