Re: --enable-locale doesn't work

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@gefi.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