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-28 14:01:05
Message-ID: 442941A1.40309@online.de (view raw or flat)
Thread:
Lists: pgsql-odbc
Hiroshi Inoue schrieb:

>
>>
>> 2. Searching for a string starting with o-Umlaut (german character) 
>> doesn't return any results (in my app.).
>>
>> 2006-03-27 16:50:37 [2931] LOG:  statement: declare "SQL_CUR0210FD50" 
>> cursor with hold for SELECT t6.* FROM KUNDE  t6 WHERE t6.name >= 'ö' 
>> AND t6.name <= 'öz' ORDER BY t6.name ASC, t6.kundenid ASC
>>
>> Maybe the WHERE-statement is not parsed by the driver. But the hex 
>> representation of 'ö' is 'C3B6', that is the correct UTF8 code (not 
>> unicode) of o-Umlaut.
>
>
> Hi Johann,
> Could you try the same query using psql with the client_encoding 'UTF8' ?
>
> regards,
> Hiroshi Inoue
>

Hi Hiroshi,

Do you mean psql on the Linux-server?

my locales:
de_DE.ISO-8859-1 (default)
de_DE.UTF-8
de_DE(dot)UTF-8(at)euro
de_DE(dot)ISO-8859-15(at)euro

I call psql:
- set client_encoding='UTF8';
- select name from kunde;
result e.g: 'öä-test' (=o-Umlaut, a-Umlaut, -test)

- select name from kunde where name >= 'ö' and name <= 'öz' order by 
name asc;

result: ERROR:  Unicode characters greater than or equal to 0x10000 are 
not supported

export LANG=de_DE.UTF-8 doesn't change the behavior.

(select name from kunde where name >= 'ö' and name <= 'öz' order by 
name asc; works of course)

regards,
Johann


In response to

Responses

pgsql-odbc by date

Next:From: Johann ZuschlagDate: 2006-03-28 14:17:19
Subject: Re: psqlODBC-Driver Test / text fields
Previous:From: postgresql.orgDate: 2006-03-27 23:51:08
Subject: Receiving INFO, WARNING, etc. (non-EXCEPTION) messages in ODBC

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