Foreign character struggles

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

Responses

Browse pgsql-sql by date

  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