Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
Resolution:
Environment
-----------------
ALL
If the datatype of a column is CHAR(10) and if the data in this column is just 4 characters then TIBCO ActiveMatrix Adapter for Database while publishing is adding 6 white spaces in the end.
From the Database ManagementSystem documentation, this is the expected behavior for both Sybase and Oracle.Entries shorter than the assigned length are blank-padded for fixed length datatype.
Workaround
----------------
As an alternative change the column type to VARCHAR or trim the white spaces for those specific columns in the receiving application