From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
---|---|
To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgreSQL(dot)org, Tamas Nyitrai <defiant(at)telnet(dot)hu> |
Subject: | Re: [GENERAL] Re: locale in postgresql |
Date: | 1998-12-14 13:37:29 |
Message-ID: | Pine.SOL2.3.96.SK.981214163127.18054F-100000@sun.med.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Clark Evans | 1998-12-14 16:46:30 | Row Level Locking, On-line Recovery |
Previous Message | Nick Urbanik | 1998-12-14 12:33:01 | RPMs for 6.4? |