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-04 13:18:45
Message-ID: 4D99C535.7030704@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
(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: Josef SpringerDate: 2011-04-04 13:47:47
Subject: Re: 08.02.04.00 Updating column with Unicode
Previous:From: Josef SpringerDate: 2011-04-03 11:50:44
Subject: 08.02.04.00 Updating column with Unicode

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