hello,

i'm experiencing a strange problem while
fetching SQL data from Pervasive 2000i database
into the Cocoon script.

The inside-Cocoon-script has the following SQL statement:

SELECT
id As Knt_KntId,
name As Knt_Name1,
'' As Knt_URL
FROM
KH

The problem is that for a database string field (FT_STRING),
Pervasive JDBC driver completes the remaining spaces of the field
with a substring "�", ie.:

Tim's Company���������

Also, when a SQL statement is like above, instructions like:
'' As Knt_URL
are fetching the following string, not an empty string as i would like it to
be:
"�"

Any one of you know how to avoid this substring to appear?

thanks for any help and suggestions
Maciej