From: Tim Perdue <tim@perdue.net>
To: pgsql-sql@postgresql.org
Subject: Foreign character struggles
Date: Fri, 25 Oct 2002 08:33:00 -0500
Message-ID: <20021025083259.B29164@mail.perdue.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tim@perdue.net
Subject: Re: Foreign character struggles
In-Reply-To: <20021025083259.B29164@mail.perdue.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox