Archives of the TeradataForum

Message Posted: Fri, 17 Sep 2010 @ 13:24:20 GMT

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

Dear members,

There was one weired error i got at the time of creating at table containg 1300 columns .

The issue coming at the time of creating the table was that "the table can't exceed the length of 64k" and this error only comes at the time when we defined more than 64k length for record at the table creation time, But when i checked the length defined for all of columns in the table then it was not more than 20k.

Using some tricks i got the solution But i am not impressed with it because i can't justfy it technicaly.

The reason behind this error was that there were too many CHAR columns in the table definition and all were defined with quote "CHARACTER SET LATIN NOT CASESPECIFIC" which is by default added to all char columns and when i remove this quote from definition the table got created successfully.

Can anyone please provide me a proper Justification for the same..

Thanks,

Vivek

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