08.02.04.00 Updating column with Unicode - Mailing list pgsql-odbc
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 ?
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 ?
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
 | Address | Josef.Springer@joops.com | Orlando-di-Lasso Str. 2 | D-85640 Putzbrunn |
 | Office | +49 (0)89 600 6920 | ||
| Fax | +49 (0)89 600 69220 | ||
 | Web | http://www.joops.com |
 | (HRB München 86239) -- the software company -- |
Attachment
pgsql-odbc by date: