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