|
|
Archives of the TeradataForum
Message Posted: Thu, 18 Nov 2010 @ 13:50:32 GMT
Subj: | | Re: Fastload and unicode data |
|
From: | | John_Wight |
When a column is marked at UNICODE, the DDL will show you only the size the user defined in the original data type specification. However, if
you look in the DD/DS at the ColumnLength column and that will tell you the actually physical size of the column. So, if you specify CHAR(1)
UNICODE for a column, the DDL will show the CHAR(10) specification but the ColumnLength will show you a size of 20 - i.e. 2 x 10. So, if you're
looking for the size of a row, always use the DD/DC ColumnLength to help get the correct answer.
JK
| |