Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 09 May 2012 @ 20:12:00 GMT


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


Subj:   Re: Spaces in Varchar
 
From:   Pluebell, Fred

For VARCHAR, neither leading nor trailing spaces are trimmed by the database. Some tools do trim spaces before sending VARCHAR data to the database, however. For CHAR, spaces will be padded or trimmed on the right to the fixed length specified.

For comparison purposes, leading spaces are significant but trailing spaces are not.

So "ABC " and "ABC" are equal, but " ABC" is different.



     
  <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: 28 Jun 2020