Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Nov 2005 @ 23:02:01 GMT


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


Subj:   Re: View column data type
 
From:   Fred W Pluebell

The expression

     CASE WHEN Column2 IS NULL then '' ELSE Column2 END Column2a

will be typed CHARACTER SET UNICODE (because literal character strings are UNICODE).

On the other hand,

     COALESCE(Column2, '') Column2b

or

     CASE WHEN Column2 IS NOT NULL THEN Column2 ELSE '' END Column2b

will have the same CHARACTER SET as Column2, e.g. LATIN.



     
  <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