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@gmx.net http://yi.org/peter-e/
