UTF8 problem

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: UTF8 problem
Date: 2006-06-08 05:23:08
Message-ID: 4487B43C.7090400@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using DBMail running against PostgreSQL as my mailstore for our
company network. I recently converted our company database from
SQL_ASCII to UTF8 as I thought this would be a *good thing*.

The problem now is that I think I'm loosing emails because in my
postgresql logs I get this:
2006-06-08 01:17:05 EDT LOG: unexpected EOF on client connection
2006-06-08 01:17:05 EDT ERROR: invalid byte sequence for encoding
"UTF8": 0xe1202c

This is by far the most common, but I'm getting a few others too such
as, 0xae, 0x85, 0x92 and more...

The basic setup is that Postfix hands the email to a program called
dbmail-smtp which parses and insert the message into the database.
DBMail doesn't know anything about encoding. I tried setting the
enviornment variable PGCLIENTENCODING=SQL_ASCII in the Postfix startup
script, but that doesn't seem to be making any difference.

Any suggestions?

Thanks,

Matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-06-08 06:05:47 Re: UTF8 problem
Previous Message Chris 2006-06-08 03:56:28 Re: A web based rewards management system for philip.immirzi@yahoo.co.uk