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.