Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Integer vs Character PI
From:   Geoffrey Rommel

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('TAIWAN ')

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020