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

Re: psqlODBC-Driver Test / text fields

From: Johann Zuschlag <zuschlag2(at)online(dot)de>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: 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 13:16:21
Message-ID: 442A88A5.30502@online.de (view raw or flat)
Thread:
Lists: pgsql-odbc
Hiroshi Inoue schrieb:
> Johann Zuschlag wrote:
>
>> Hiroshi Inoue schrieb:
>>
>>>
>>> Hmm utf8 code of a-umlaut seems bigger than 'z' .
>>>
>>> Well how is the result of the following(original ?) query
>>>    under default encoding ?
>>>
>>>  select name from kunde where name >= 'ö' and name <= 'öz' order by 
>>> name asc;
>>>
>> ERROR:  Unicode characters greater than or equal to 0x10000 are not 
>> supported
>
>
> With the default encoding(ISO-8859-1 ?) ?
>
Oh, I misunderstood you. Do you mean the database default encoding?
IIRC ISO-8859-1 would be equivalent to LATIN1?
I generated a new database with the same data in LATIN1:

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...

Regards,
Johann


In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-03-29 14:34:50
Subject: Re: psqlODBC-Driver Test / text fields
Previous:From: vidisha.shahDate: 2006-03-29 10:35:16
Subject: Re: [ODBC] Unable to Query the datatype varchar of PostgreSQL Server

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