Skip site navigation (1) Skip section navigation (2)

Re: --enable-locale doesn't work

From: werner <werner(at)gefi(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: --enable-locale doesn't work
Date: 2000-04-02 14:07:51
Message-ID: 38E75437.694F6748@gefi.at (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
I found a solution for the problem. But first I try to explain a little
bit better what the poblem was. When I
searched for a text that contained foreign characters (ä,ö,ü,etc.) the
query found no matching records.

for example:

create table mytesttable(myattribute text);

insert into mytesttable values('FRÜHLING');

select * from mytesttable where myattribute~*'frühling';

The query finds no matching records. But it works if the "special
characters" are the same case (i.e. "frühling",
"Frühling","FRüHLING",etc.)
(frühling is the german word for spring :-) btw)

In postgresql versions before 7.x  the parameter --enable-locale was
necessary to search for these
characters.  Now I found out that in 7.0 the parameter --enable-recode is
necessary.  The manual says that
this parameter is for cyrillic recode support only. But the german
character set ISO-8859-1 (I use) is not
cyrillic. So I was a little confused. I'm not sure what the diffrence
between --enable-locale and
--enable-recode is. Anyway, it seems like --enable-recode is necessary to
make a search on attributes that use german character sets.


PS.: I'm afraid that  if you don't have a german character set, you can't
really read this message, because the "special characters" are not
translated. The character "ü" should be shown as a small u with 2 points
above.

Tom Lane wrote:

> werner <werner(at)gefi(dot)at> writes:
> > I'm running the 7.0 beta 3. It seems like queries that use german
> > characters like ü,ä,ö or ß don't work with the ~*
> > Operator (case insensetive regex). It only works with case sensetive
> > queries. So the configure option
> > --enable-locale doesn't have any influence.
>
> This isn't enough information.  What exactly do you mean by "doesn't
> work"?  What query did you issue, what result did you get, what did
> you expect to get?  And which locale are you using?
>
>                         regards, tom lane


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-04-02 14:18:10
Subject: Re: src/test/locale/de_DE.ISO-8859-1
Previous:From: Oleg BroytmannDate: 2000-04-02 12:10:21
Subject: Re: [HACKERS] Re: --enable-locale doesn't work

pgsql-bugs by date

Next:From: Marc BaudoinDate: 2000-04-02 20:36:19
Subject: [7.0beta3] Bug in initdb
Previous:From: Oleg BroytmannDate: 2000-04-02 12:10:21
Subject: Re: [HACKERS] Re: --enable-locale doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group