Archives of the TeradataForum

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

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

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