Archives of the TeradataForum
Message Posted: Mon, 20 Aug 2001 @ 20:42:30 GMT
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:
do NOT return the same value, because the first is fixed and the second is variable.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|