Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2012 @ 22:04:58 GMT

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

Subj:   Re: Valid trailing spaces in key values
From:   Anomy Anom

<-- Anonymously Posted: Thursday, February 23, 2012 16:30 -->

This is bad practice. Note that in standard SQL, 'abc ' is equal to 'abc'.

If you make the Teradata field VARCHAR, it is possible to load data with a varying number of trailing spaces - though you have to be careful because some tools will strip trailing spaces by default.

And don't forget that your applications will need to compare both column values and the CHARACTER_LENGTH of the columns to tell them apart in Teradata. Or else you use some other clumsy workaround, like concatenating a dummy non-blank character on the end so that the spaces are embedded (and therefore significant) rather than trailing.

  <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