Subject Re: Unnecessary padding to Strings read
Author Roman Rokytskyy
> Recently we configured the JBoss 3.0.x server to use firebird driver
> FirebirdSQL1.0.1 to access our Interbase Unicode database. On
> testing this configuration, while reading certain columns in the
> table either char or varchar, the string read as an extra padding at
> the end. I am not sure why this is happening? Has anyone seen a
> similar problem? Is there a solution to this problem?

Columns defined as CHAR are padded to full length by server according
to SQL standard. VARCHAR columns are not padded. If you can provide a
reproducable test case where _VARCHAR_ columns are padded, I will
consider this a bug, but I'm almost 100% sure that you get the issue
with CHAR columns and this is correct behavior.

Best regards,
Roman Rokytskyy