Archives of the TeradataForum

Message Posted: Tue, 21 Aug 2001 @ 13:18:17 GMT

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

Only a gues: select hashrow('0004132'); produces VARCHAR(7) CHARACTER SET UNICODE and in the table statement is defined as character set latin. If you define all in the same charater set the result will be the same.

CREATE SET TABLE hasher ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      char01 CHAR(7) CHARACTER SET unicode NOT CASESPECIFIC,
      vch02 VARCHAR(20) CHARACTER SET unicode NOT CASESPECIFIC)
UNIQUE PRIMARY INDEX ( char01 );

insert into hasher ('0004132','0004132');

select hashrow(char01), hashrow(vch02)
 from hasher;

select hashrow('0004132');

Ulrich

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