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

Re: 08.02.04.00 Updating column with Unicode

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: 08.02.04.00 Updating column with Unicode
Date: 2011-04-04 13:47:47
Message-ID: 4D99CC03.2020509@joops.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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
/
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:38:35
Subject: Re: 08.02.04.00 Updating column with Unicode
Previous:From: Hiroshi InoueDate: 2011-04-04 13:18:45
Subject: Re: 08.02.04.00 Updating column with Unicode

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