Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Jul 2007 @ 17:05:19 GMT


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


Subj:   Unicode surprise
 
From:   David Clough

I've just created a Unicode table, based upon an equivalent Latin table, and Inserted the 11 million rows into it.

When I looked at the Perm space of both I was surprised to see that, whilst the data does not actually contain any two-byte character data, the difference between the two tables was considerable :

Latin table : 394,586,112 bytes

Unicode table : 618,798,592 bytes


For those in the know, does this mean that wherever I create Character based columns in Unicode, we'll have to accept a vast increase in actual Perm space used ?

I was under the apparent misapprehension that Teradata would only use the extra space if it actually contains double byte characters, otherwise it would not take up any more actual space than the equivalent in Latin definitions.

I'm concerned; all my new tables are supposed to be Unicode compliant.

Can anyone enlighten me ?

Dave Clough
Database Designer
Express ICS

www.tnt.com



     
  <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: 27 Dec 2016