From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Rickard Annell <Rickard(dot)Annell(at)udac(dot)se> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Swedish characters |
Date: | 2001-03-15 16:04:38 |
Message-ID: | 13926.984672278@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Rickard Annell <Rickard(dot)Annell(at)udac(dot)se> writes:
> ./configure --prefix=/service/database/postgres_test --enable-odbc
> --enable-local
> export LC_ALL=sv_SE
> export LC_CTYPE=sv_SE
> export LC_COLLATE=sv_SE
> nohup ./postmaster -p 5431 -i >server.log 2>&1 &
You do know that under 7.1, the important LC_ values are the ones that
initdb sees, not the ones that the postmaster sees, right? Can't tell
from this snippet whether you initdb'd in Swedish locale or not.
> create table test (id int , name varchar,primary key(id));
> insert into test values (1,'sbrink');
> select * from test where lower(name) like '%%';
> id | name
> ----+------
> (0 rows)
Is this a bug? I'd sort of think that '' is not lower case
(although maybe my mail reader isn't presenting it in the right
font ... it looks like an accented upper case I to me, but what
do you think it is?). Shouldn't you say "where lower(name) like
lower('%%')"? Or perhaps use ILIKE to get a case-insensitive
compare.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2001-03-15 16:49:49 | Using types in an inappropriate way causes crash of backend |
Previous Message | Peter Eisentraut | 2001-03-15 15:54:29 | Re: Swedish characters |