Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2012 @ 20:56:11 GMT


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


Subj:   Re: Actual size of CLOB fields
 
From:   Dieter Noeth

Anomy.Anom wrote:

  Is the a way to determine the actual characters in a CLOB field. Similar to the way CHARACTERS determine the actual size of a VARCHAR field.  


CHAR_LENGTH(clob)?

If you don't want to use CHARACTERS/CHAR_LENGTH there are some more synonyms :-)

     CHARACTER CHARS CHAR CHARACTER_LENGTH

Btw, for BLOBs there's BYTES.


Dieter



     
  <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