JDBC Adapter: Returning Space-Filled Strings for CHAR Colum

, ,
1

When I run a selectSQL adapter against my SQL2K db it returns my char colums as strings (as it should) but it then pads them with spaces up to the length the column is configured for in SQL.

ex. If I select a field called X which is a Char(10) and it contains “ABC” webMethods will put "ABC " in the pipe.

This is very anoying. Can it be stopped?

I’m selecting a lot of data and I don’t want to have to run a “Trim” for each field.

Thanks.

Luke.

2

Luke, This is the default behavior of the database for CHAR type field columns.

3

If you don’t have control over the database field type, you could also wrap your sql column expressions with rtrim(), if you don’t want to trim them in your flow.