[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-25 Thread valgog
On Jul 25, 10:17 am, [EMAIL PROTECTED] (Zdenek Kotala) wrote: > Valentine Gogichashvili napsal(a): > > > Hi, > > Hi > > > I understand, that it is more a feature, but it does not help me anyways... > > > On the UNICODE databases lower and upper functions are using system locale > > settings (that c

Re: [BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-23 Thread Tomasz Ostrowski
On 2008-07-23 11:48, valgog wrote: > Another question. Is it possible to change the current Database > LC_CTYPE on the database without recreating it with initdb and > reimporting all the data. No. > I would rather prefer my indexes recreated, rather then reimporting > database (cannot afford su

[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-23 Thread valgog
I checked for de_DE.utf8 (created a test database with initdb) and lower/upper is working correctly there on both 8.2 and 8.3 in different languages On Jul 22, 11:26 am, valgog <[EMAIL PROTECTED]> wrote: > On Jul 21, 4:32 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > > > > Valentine Gogichash

[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-23 Thread valgog
On Jul 22, 11:53 am, [EMAIL PROTECTED] (Peter Eisentraut) wrote: > Am Tuesday, 22. July 2008 schrieb valgog: > > > Why Postgres allows creating UNICODE database with the locale, that > > can possibly corrupt my data? > > It doesn't allow it, as of 8.3.  In 8.2 it does, but we have fixed that, for >

Re: [BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-22 Thread Peter Eisentraut
Am Tuesday, 22. July 2008 schrieb valgog: > Why Postgres allows creating UNICODE database with the locale, that > can possibly corrupt my data? It doesn't allow it, as of 8.3. In 8.2 it does, but we have fixed that, for the reasons that are becoming obvious to you now. Perhaps part of the probl

[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-22 Thread valgog
On Jul 21, 4:32 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > Valentine Gogichashvili escribió: > > > On 8.2.3 database with LC_CTYPE set to en_EN, lower() function is actually > > corrupting UTF8 data, lowering UTF8 control bytes... I did have a chance to > > check if how it works on the 8.3 as

[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-22 Thread valgog
On Jul 21, 4:32 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > Valentine Gogichashvili escribió: > > > On 8.2.3 database with LC_CTYPE set to en_EN, lower() function is actually > > corrupting UTF8 data, lowering UTF8 control bytes... I did have a chance to > > check if how it works on the 8.3 as