Archives of the TeradataForum
Message Posted: Fri, 06 Jul 2007 @ 17:05:19 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|