> > > - Some letters, like the euro sign, do not belong to Latin1. Example: let's
> > > say we have a Latin1 database and use SET CLIENT_ENCODING = 'Unicode'. If I
> > > input a euro sign, does it get rejected by PostgreSQL?
> >
> > Currently, it gives you a warning and ignores the character. Not sure
> > that is ideal.
>
> (Yes, I should try this myself...)
>
> Ignored as in 'passed through unchanged'; or ignored as in 'removed from
> the string'?
"removed from the string". BTW, if I remember correctly, the euro sign is
supported in ISO-8859-16, not in ISO-8859-1.
--
Tatsuo Ishii