CREATE TABLE Failed [3737] - NAME REQUIRES MORE THAN 30 bytes IN LATIN INTERNAL FORM

Database
Enthusiast

CREATE TABLE Failed [3737] - NAME REQUIRES MORE THAN 30 bytes IN LATIN INTERNAL FORM

When I run the create statement got this error. I know that table name or column name should be less than 30 characters.

But the question is why its "more than 30 bytes in LATIN INTERNAL FORM"? What this statement means? This 30 bytes denotes table name or column name or something else?

2 REPLIES
Teradata Employee

Re: CREATE TABLE Failed [3737] - NAME REQUIRES MORE THAN 30 bytes IN LATIN INTERNAL FORM

With the Teradata Database 14.10 Extended Object Names feature, name lengths have been increased to 128. However, this depends on the NameValidationRule setting in DBSControl. See the Extended Object Names Orange Book, or Utilities and SQL Fundamentals reference, for more details.

-Dave

Teradata Employee

Re: CREATE TABLE Failed [3737] - NAME REQUIRES MORE THAN 30 bytes IN LATIN INTERNAL FORM

The message about latin internal form is a reference to the fact that names of objects may now contain non-latin characters. If characters are used that require two bytes to store, then the number of characters that can be included in the name will be less. The total storage is 30 bytes, not the total characters. And as Dave mentiioned, the 30 byte limit has been lifted in current releases if the feature is enabled.