Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Aug 2006 @ 19:28:43 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023