"John D. Burger" <john@mitre.org> writes:
>> My queries are utf-8 an the database is SQL_ASCII.
> I suspect the bracketed expression is turning into [aXY], where XY is
> the two-byte sequence corresponding to � in UTF8.
That's what it looks like to me. You can hardly blame the database for
this, when you haven't clued it in that you're using UTF8.
> I don't know if a UTF8 database will handle this correctly or not.
I believe that it will work in recent PG releases (7.4 and up).
regards, tom lane