Archives of the TeradataForum

Message Posted: Fri, 18 Mar 2005 @ 11:46:41 GMT

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

There are a number of data type pairs which give the same hash value for the same data value

Date ,Integer, Smallint, Byteint are all the same.

Char, Varchar are all the same

Some Decimals will match the hash values given by Integer, date etc - decimal(4,0) is one.

Does this help ?

Cheers,

Dave

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