I compiled postgres with --enable-multibyte and --enable-recode, and it doesn't appear to help with my problem.
I have a database which contains "foreign" characters in city names, like "São Paulo" (Sao Paulo). If an end-user types plain-english Sao Paulo, I want the database to pull up "São Paulo", essentially just treating the accented characters as if they were regular ASCII. select to_ascii(city) from latlong where ccode='BR'; ERROR: pg_to_ascii(): unsupported encoding from SQL_ASCII select convert(city,'UNICODE', 'LATIN1') from latlong where ccode='BR'; ERROR: Could not convert UTF-8 to ISO8859-1 Also, my "Up Arrow" and "Delete" keys no longer work since I recompiled 7.2.3 on debian. Thanks for any help, Tim Perdue ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
