"John D. Burger" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq