Archives of the TeradataForum

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

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

<-- 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>>