Archives of the TeradataForum
Message Posted: Thu, 23 Feb 2012 @ 20:32:52 GMT
<-- 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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|