Archives of the TeradataForum

Message Posted: Mon, 08 Aug 2011 @ 14:39:30 GMT

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

Hi ,

I am finding that a char column stores data with spaces (if all characters upto the length of the column are not given) but is able to return the row when compared without giving spaces for the column.

Please explain the behavior.

PFB the script :

     Create table test_char (col1 char(3));

     Insert into test_char ( col1 ) values ('%');

     sel col1 from test_char where col1 = '%';  (Please note that there are no spaces here)

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     col1
     ----
     %

     sel col1 from test_char where col1 = '%  ';   (Please note the spaces here)

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     col1
     ----
     %

Thanks and Regards,

Gagan

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