Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Aug 2006 @ 10:03:18 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Missbehaving char/varchar data in teradata sql assistent
From:   Victor Sokovin

  Glad we found a reason why the comparison succeeded. May be it's the same reason for below error too.  

Yes, I think so. As your table defaults to SET and has only one column in it the PI actually becomes a UPI so the check for uniqueness is done every time a new value is inserted in the column. As the two values in your example are the same (in terms of comparison of strings of unequal length) the second value is rejected.



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