Re: [GENERAL] Re: locale in postgresql

Hi!

On Sun, 13 Dec 1998, Oliver Elphick wrote:
> Tamas Nyitrai wrote:
> [in relation to 6.3.2, where this happens:
>   test=> select * from test;
>   name
>   ----
>   abc
>   bca
>   cab
>   (3 rows)
>
>   test=> select * from test where name like 'a%';
>   name
>   ----
>   (0 rows)]
>
>
> Has anyone else seen such a locale-based problem?
>
> I would like to establish whether it is a problem in postgresql or in
> libc.

   Works fine for me with 6.4 on 2 platforms:
   (Sun Solaris 2.5.1, locale=koi8-r (unix cyrillic))
   (x86 Debian 2.0, locale=koi8-r)

test=> create table test (name text, value int);
CREATE
test=> insert into test values('abc', 1);
INSERT 67895 1
test=> insert into test values('bca', 2);
INSERT 67896 1
test=> insert into test values('cab', 3);
INSERT 67897 1
test=> select name from test;
name
----
abc
bca
cab
(3 rows)

test=> select name from test where name like 'a%';
name
----
abc
(1 row)

test=> select * from test where name like 'a%';
name|value
----+-----
abc |    1
(1 row)

Oleg.
----
    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/
           Programmers don't die, they just GOSUB without RETURN.