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

Re: psqlODBC-Driver Test / text fields

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Johann Zuschlag <zuschlag2(at)online(dot)de>
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-28 15:38:21
Message-ID: 4429586D.30303@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Johann Zuschlag wrote:

> Hiroshi Inoue schrieb:
>
>>
>> Thanks.
>> Could you issue the following 2 queries
>>
>>  select name from kunde where name >= 'ö' order by name asc;
>>
>   name
> --------
> öä-test
> öäüÃÃ
>          ÃÃ-test
> (2 Zeilen)
>
>>  select name from kunde where name <= 'öz' order by name asc;
>>
>  name
> --------
> Hühne
> Müller
> Täst
> test
> test-2
> (5 Zeilen)


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;

regards,
Hiroshi inoue

In response to

Responses

pgsql-odbc by date

Next:From: Campbell, GregDate: 2006-03-28 16:05:53
Subject: Re: psqlODBC-Driver Test / text fields
Previous:From: Johann ZuschlagDate: 2006-03-28 14:54:09
Subject: Re: psqlODBC-Driver Test / text fields

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