Re: 08.02.04.00 Updating column with Unicode - Mailing list 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