08.02.04.00 Updating column with Unicode does not work

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 EUR ??'' 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 EUR), it works.

It seems that:
*SQLExecute handles UTF8 encoded character in the right way
SQLBindParameter handles UTF8 encoded character** in the wrong way (bad
encoding)
*
Can anybody give me some hints ?

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

Postal
Address
_Josef(dot)Springer(at)joops(dot)com_
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
Phone
Office
+49 (0)89 600 6920


Phone Fax
+49 (0)89 600 69220


Web
Web
http://www.joops.com

JOOPS
(HRB München 86239)

*-- the software company --*