|
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 7:09:10 PM
Posts: 125,
Visits: 276
|
|
Teradata Database Messages manual states:
Explanation: Quoted strings cannot be longer than 31000 physical characters.
Notes: To insert longer strings, the user must have a USING clause and a DATA parcel that contain the characters.
Are you using a Character Literal (e.g. Insert into file_storage(1.0, 'xyz')) to insert the data?
Shaw
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/15/2008 9:11:28 AM
Posts: 27,
Visits: 77
|
|
Hi
It depends on the version of Teradata you are using.
May be yours support only maximum of 32000 characters..
Cheers:-)
smilever
|
|
|
|