From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Tim Perdue <tim(at)perdue(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Foreign character struggles |
Date: | 2002-10-25 14:37:59 |
Message-ID: | 22964.1035556679@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Tim Perdue <tim(at)perdue(dot)net> writes:
> I compiled postgres with --enable-multibyte and --enable-recode, and it
> doesn't appear to help with my problem.
I think this is a locale issue, not a character set issue. You
definitely need --enable-locale, but I doubt you need either of the
above (unless you need to deal with Unicode or Far-Eastern languages).
> 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.
I'd suggest matching on "upper(city)" to get rid of accents; given the
right locale setting that should work, and you can add a functional
index to make it fast.
> Also, my "Up Arrow" and "Delete" keys no longer work since I recompiled 7.2.3
> on debian.
You are missing libreadline.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-10-25 14:49:41 | Re: Foreign character struggles |
Previous Message | Tony Grant | 2002-10-25 14:36:14 | Re: Foreign character struggles |