Archives of the TeradataForum
Message Posted: Fri, 04 Aug 2006 @ 19:28:43 GMT
| Subj: | | Re: Missbehaving char/varchar data in teradata sql assistent |
| |
| From: | | Dempsey, Mike |
If the column is Varchar there will be no blank padding when the data is returned (unless blank padding existed when the data was
inserted).
When you insert data to a (fixed length) char field it will be padded with blanks before it is stored. (I suspect Oracle does the same.) For
some reason however Oracle (or the app you used to read the Oracle data) truncates any blanks from the field before displaying/writing it.
(Strictly speaking that means it is corrupting the data.) SQL Assistant on the other hand displays exactly what the column contains.
Mike Dempsey
Teradata Client Tools
| 
