Failure 3738: String is longer than 31000 characters

Tools
Enthusiast

Failure 3738: String is longer than 31000 characters

Hi,
I am trying to insert a string of length approx 32000 into a table with the definition as shown below:

Request Text
CREATE SET TABLE file_storage ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
version_id DECIMAL(10,2),
file_data VARCHAR(60000) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( version_id );

This is giving me the following error:
Failure 3738: String is longer than 31000 characters.

If the field 'file_data' is defined with length 60000 then why is this failing?
Thanks.
1 REPLY
Enthusiast

Re: Failure 3738: String is longer than 31000 characters

It depends on the version of Teradata you are using.
May be yours support only maximum of 32000 characters..

Cheers:-)
smilever