On Fri, 2002-10-25 at 15:33, Tim Perdue wrote:
> I compiled postgres with --enable-multibyte and --enable-recode, and it
> doesn't appear to help with my problem.
createdb my_db_name -E LATIN1
Worked just fine for me but the client wanted to be able to search with
accents so I turned the to_ascii
On Fri, Oct 25, 2002 at 12:24:43PM -0400, Tom Lane wrote:
> If you skipped enable-locale then you are outta luck. The fact that
> there is a connection between "a" and "accented a" is purely a locale
> issue.
What I meant was, if I recompile --enable-locale and install over the current
builds, I
Tim Perdue <[EMAIL PROTECTED]> writes:
> I skipped --enable-locale because I feared I would have to dump/restore
> all my databases and require re-testing the application. Is that unfounded?
If you skipped enable-locale then you are outta luck. The fact that
there is a connection between "a" and
On Fri, Oct 25, 2002 at 10:37:59AM -0400, Tom Lane wrote:
> Tim Perdue <[EMAIL PROTECTED]> 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
> definitel
Roberto Mello <[EMAIL PROTECTED]> writes:
> Where is the procedure for working with i18n'd characters described in the
> documentation? I'm looking for something that mentions the specifics of
> locale interaction and all that.
Offhand I can't think of any section that addresses that topic
specif
On Fri, Oct 25, 2002 at 10:37:59AM -0400, Tom Lane wrote:
>
> 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).
Where is the procedure for w
Tim Perdue <[EMAIL PROTECTED]> 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 (unle
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 Pau
