Skip site navigation (1) Skip section navigation (2)

Re: psqlODBC-Driver Test / text fields

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Johann Zuschlag <zuschlag2(at)online(dot)de>
Cc: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>, dpage(at)vale-housing(dot)co(dot)uk, pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC-Driver Test / text fields
Date: 2006-03-29 14:34:50
Message-ID: 20060329143450.GG18148@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> test-latin1=# select name from kunde order by name asc;
> name
> --------------
> Hühne
> Müller
> Täst
> test
> test-2
> öä-test
> öäüÖÄÜß-test
> (7 Zeilen)
> 
> test-latin1=# select name from kunde where name >= 'ö' and name <= 'öz' 
> order by name asc;
> name
> ------
> (0 Zeilen)
> 
> And please note the following:
> 
> test-latin1=# select name from kunde where name >= 'ö' and name <= 'ö' 
> order by name asc;
> name
> ------
> (0 Zeilen)
> 
> Hmm...

The last query is equivalent with:
select name from kunde where name = 'ö'

So I'm not surprised with the result ;-)

What is the locale for backend? Isn't this the real problem?

When you have the problem in psql client feel free to ask
in another pgsql-* mailing list. It isn't odbc related bug.
Maybe we solve your problem but maybe you get the right advice
faster in another list.

Regards,

Luf

In response to

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2006-03-29 14:38:21
Subject: Re: psqlODBC-Driver Test / text fields
Previous:From: Johann ZuschlagDate: 2006-03-29 13:16:21
Subject: Re: psqlODBC-Driver Test / text fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group