Archives of the TeradataForum

Message Posted: Mon, 20 Aug 2001 @ 20:42:30 GMT

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

I tried this on my system, and it worked just fine as either integer or char. We'll need to see your DDL. These possibilities come to mind...

- All the character indexes must be exactly the same length -- but you've probably thought of this already.

- When you join, are you including any literals? Character literals are stored as VARCHAR, not CHAR. For instance, if you have a char(10) column that includes 'TAIWAN ', the following expressions:

hashrow(char10_column)
hashrow('TAIWAN ')

do NOT return the same value, because the first is fixed and the second is variable.

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