I have an ODBC connection set up to Oracle.  This connection can be used by Excel to retrieve data with no problem.  However, when I attempt to use the tDBInput connection in Talend, my data is truncated.  For example, I have the following columns with the Oracle datatypes:

CurrentPeriod - char(6)
CurrentProductYear - char(6)
ProductCode - char(5)

I set these to "character" types in TOS (ver 2.2.0GA_r6191).  When I run the query, I get these results from tLogRow:

2|2|M
2|2|M
2|2|M
2|2|M
2|2|M

The data appears to be truncated.  I have tried both "String" and "Character" types in Talend and changed the length settings in the schema.  Any ideas on this?

Thanks - headjoog