From: | Rickard Annell <Rickard(dot)Annell(at)udac(dot)se> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Swedish characters |
Date: | 2001-03-15 12:43:38 |
Message-ID: | p05010401b6d6660d1131@[193.44.77.126] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Rickard Annell
Your email address : Rickard(dot)Annell(at)udac(dot)se
System Configuration
---------------------
Architecture (example: Intel Pentium) : PowerPC 604e
Operating System (example: Linux 2.0.26 ELF) : AIX v 4.3.3
PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1beta5
Compiler used (example: gcc 2.8.0) : gcc v. 2.95.2
Please enter a FULL description of your problem:
------------------------------------------------
Problem with match swedish characters in SQL query.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
./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 &
./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.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
--
___________________________________________________________________
Rickard Annell E-mail: Rickard(dot)Annell(at)udac(dot)se
SYSteam Udac WWW: http://www.udac.se
Tel: +46 (0)18 4717700
Box 174, S-751 04 Uppsala, Sweden Fax: +46 (0)18 516600
From | Date | Subject | |
---|---|---|---|
Next Message | Lonnie Cumberland | 2001-03-15 13:09:49 | iodbc and Postgresql 7.0.3 update |
Previous Message | Lonnie Cumberland | 2001-03-14 19:26:21 | Re: odbc bug? |