Foreign character struggles
От | Tim Perdue |
---|---|
Тема | Foreign character struggles |
Дата | |
Msg-id | 20021025083259.B29164@mail.perdue.net обсуждение исходный текст |
Ответы |
Re: Foreign character struggles
Re: Foreign character struggles |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: