Archives of the TeradataForum
Message Posted: Thu, 23 Feb 2012 @ 20:32:52 GMT
| Subj: | | Valid trailing spaces in key values |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, February 23, 2012 13:56 -->
We are trying to convert data from Oracle to Teradata. There is a key column in Oracle that has trailing spaces that are valid spaces for the
key value. For example:
'abc ' is different from 'abc'. We can not load into a character field because it will add trailing spaces and the value of 'abc ' (three
tailing spaces) will be different than 'abc ' (five tailing spaces). If we define as varchar, the trailing spaces are removed.
Does anyone have a work around for this problem?
| 
