|
|
|
Junior Member
 
Group: Forum Members
Last Login: 9/23/2008 3:15:52 PM
Posts: 18,
Visits: 10
|
|
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.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/15/2008 9:11:28 AM
Posts: 27,
Visits: 77
|
|
It depends on the version of Teradata you are using.
May be yours support only maximum of 32000 characters..
Cheers:-)
smilever
smilever
|
|
|
|