Re: Swedish characters

Rickard Annell writes:

> ./configure --prefix=/service/database/postgres_test --enable-odbc
> --enable-local

--enable-locale

> export LC_ALL=sv_SE
> export LC_CTYPE=sv_SE
> export LC_COLLATE=sv_SE
>
> nohup ./postmaster -p 5431 -i >server.log 2>&1 &
> ./createdb -p 5431 cybertest
> ./psql -p 5431 cybertest
> 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)
>
> I think "lower(name) like '%å%'" should match. If i try "lower(name)
> like '%Å%'" I get one row.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/