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.


Sat, 01 Apr 2000 21:31:50 +0200
werner <werner@gefi.at>
--enable-locale doesn't work
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

Sun, 02 Apr 2000 00:41:13 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: --enable-locale doesn't work 
On Sun, 2 Apr 2000, 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?

   Just tested beta3 - working like a charm, as usual :) Are you sure you
have correct locale settings? Look into src/test/locale directory; there
you'll find locale test for some locales, including de_DE.ISO-8859-1. Run
the test (make all test-de_DE.ISO-8859-1). Watch the results - is your
locale ok?
   If you are sure your locale is Ok, but still unsatisfied with locale
test - send your patches to me, please.

Oleg.
---- 
    Oleg Broytmann    http://members.xoom.com/phd2.1/    phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.


Sun, 2 Apr 2000 12:10:21 +0000 (GMT)
Oleg Broytmann <phd@phd.russ.ru>
Re: [HACKERS] 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


Sun, 02 Apr 2000 16:07:51 +0200
werner <werner@gefi.at>
Re: --enable-locale doesn't work
Works like a charm here. Be sure to set the locale-relevant environment
variables (e.g., LC_ALL) in the environment of the postmaster.

werner 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.
> 
> 

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Sun, 2 Apr 2000 23:17:59 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: --enable-locale doesn't work