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

Re: 08.02.04.00 Updating column with Unicode

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: 08.02.04.00 Updating column with Unicode
Date: 2011-04-05 03:38:35
Message-ID: 4D9A8EBB.5040703@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Josef,

(2011/04/04 22:47), Josef Springer wrote:
> Hi Hiroshi,
>
> the parameters are bound as an UTF8-encoded bytearray. Because the
> interface is controlled by a Smalltalk application, i think the codings
> does not help you:
> /bytes := v asByteArrayEncoding: #'utf-8'.
> p copyAt: 0 from: bytes size: (size := bytes size) startingAt: 1.
> p at: size put: 0
> /

Unfortunately I know nothing about Smalltalk.
Anyway *Unicode* means UTF-16 as for the drivers.
Could you try to give utf-16 strings?

regards,
Hiroshi Inoue

> Josef Springer
>
> Hiroshi Inoue wrote:
>> (2011/04/03 20:50), Josef Springer wrote:
>>> Hello everybody,
>>>
>>> I have detected some strange behavior updating columns with Unicodes
>>> strings.
>>>
>>> Environment:
>>> PostgreSQL 8.2.5
>>> Database encoding: UTF8
>>> ODBC: PostgreSQL Unicode Version 08.02.04.00
>>>
>>> I am updating via ODBC a column (character varying nnn) of a record to
>>> an unicoded string.
>>>
>>> Updating by using the command as one parameterblock
>>> 'UPDATE adresse SET company = ''Seifert und Partner KG € 文件'' WHERE id
>>> = 1'
>>> works right. (the whole parameterblock is encoded to UTF8)
>>>
>>> Updating the record by using the command 'UPDATE adresse SET company=?
>>> WHERE record.id=?'
>>> and providing the arguments for ? UTF8-encoded in an extra buffer
>>> destroys the columns content.
>>>
>>> If i update the column with an UTF8 encoded character in the default
>>> range (the EURO Sign €), it works.
>>>
>>> Can anybody give me some hints ?
>>
>> How do you bind the parameters?
>>
>> regards,
>> Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2011-04-05 03:45:22
Subject: Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
Previous:From: Josef SpringerDate: 2011-04-04 13:47:47
Subject: Re: 08.02.04.00 Updating column with Unicode

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