Archives of the TeradataForum
Message Posted: Mon, 29 Aug 2011 @ 16:39:24 GMT
We keep encountering a problem where we set our attribute lengths to similar sizes based on the source system definition. In this case the source system is Oracle and even though we have set the attribute definition in Teradata to Unicode, we keep encountering truncation errors.
Have others encountered this problem? Is there some system parameter we are missing that would provide closer correspondence between Oracle and Teradata multibyte character sizes?
As you can see below, the recommendation is to increase the TD character size by 3 times the Oracle size for all Unicode attributes.
Currently we have defined it has VARCHAR(150) where in Oracle it is defined as VARCHAR(100), but in Oracle it is accepting 100 characters irrespective of UNICODE or LATIN and how many bytes each character is occupying, wherein Teradata it accepting only 150 bytes even though we are receiving 50- 60 characters length values from source.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|