From: | Tim Perdue <tim(at)perdue(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Foreign character struggles |
Date: | 2002-10-25 13:33:00 |
Message-ID: | 20021025083259.B29164@mail.perdue.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 "So
Paulo" (Sao Paulo).
If an end-user types plain-english Sao Paulo, I want the database to pull up
"So 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
From | Date | Subject | |
---|---|---|---|
Next Message | Denise Bossarte | 2002-10-25 14:36:07 | VACUUM and locking |
Previous Message | Achilleus Mantzios | 2002-10-25 12:51:26 | Re: Upper / lower cases on table and column names |