Consultor Eletrônico



Kbase P9973: Prepared statements fail when extended characters are passed as parameters
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/10/2008
Status: Verified

FACT(s) (Environment):

Windows NT 32 Intel/Windows 2000
Progress 9.1x

SYMPTOM(s):

Extended characters like é, è or ê are transformed in the JDBC driver into two characters with PreparedStatement.setString() or setObject methods.

For any kind of dynamic prepare statement that has "?" parameters, the execution of such statements will fail if the given values of those "?" character type parameters contain non-ASCII letters.

Prepared statements fail when extended characters are passed as parameters

[JDBC Progress Driver]:String data, right truncated

CAUSE:

This is a bug for supporting non-ASCII international characters in the JDBC driver.

CAUSE:

Bug# 20020926-016

FIX:

Upgrade to Progress 9.1D Service Pack 9 or later.