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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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