How to avoid padding of white spaces to columns with datatype CHAR?
Article ID: KB0088971
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
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
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
Issue/Introduction
How to avoid padding of white spaces to columns with datatype CHAR?
Feedback
Yes
No
Powered by
