Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Nov 2005 @ 20:12:51 GMT


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


Subj:   Re: View column data type
 
From:   Dempsey, Mike

When the length is double the format size that implies Unicode data.

It would appear that the Case statement is returning Unicode but the Coalesce is returning ANSI. (If you intended to say 'Column2b' in the second case.)

Just as a performance note, it would be much faster to issue

     help column ..*

than a separate 'help' statements for each column.


Mike Dempsey
Teradata Client Tools



     
  <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: 15 Jun 2023