From: | Steve Atkins <steve(at)blighty(dot)com> |
---|---|
To: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need help with quote escaping in exim for postgresql |
Date: | 2006-07-12 02:14:21 |
Message-ID: | D55F7B82-CA74-403D-BA17-3428BD20B75C@blighty.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jul 11, 2006, at 6:29 PM, Bruno Wolff III wrote:
>>> SQL_ASCII may also be an option (assign no special meaning to
>>> characters at all), but I'm less sure of that. Can email address
>>> contain multibyte characters? I didn't think so...
>>
>> E-Mail addreses themselves can't, but the "comment" field of an
>> address can.
>
> The comment field itself, in RFC2822 addresses is ascii. However
> there is
> a hack, by which this ascii string may be interpretted as
> representing a
> string in another encoding. I don't remember the number of the RFC
> describing
> how this works, but it shouldn't be hard to find.
RFC 1522. Whether you'd want to open that can of worms
by decoding headers in that format to some other character
set for email is a good question (especially as a lot of spam
has headers that end up containing illegal characters if
you do that).
If you were to do that you'd probably have to deal with
i18n domain name encoding too, which is even more hideous.
Fortunately all this stuff is MUA-side, not MTA-side, so exim
should ignore it. SQL_ASCII all the way.
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2006-07-12 02:19:57 | Re: US Telephone Number Type |
Previous Message | John DeSoi | 2006-07-12 02:10:33 | Re: Passwords problems |