I get the following error while trying to insert a String (containing apostrophes, 33121 characters in total) into VARCHAR(35000) field:
INSERT Failed. 3738: String is longer than 31000 characters.
Is there an alternative way to insert data? Like different data type or special procedures? I use Teradata 13.10.07.21 version. I'm not sure if this question was already asked and resolved (I browsed through and did not find an alternative way to insert data).
It seems you are trying to insert an explicit string using quotes (''). The quoted strings cannot exceed 31000 chars. Your option is using an IMPORT file with the strings that you need to insert with a USING clause:
.IMPORT VARTEXT FILE blah.txt
USING (long_string VARCHAR(35000),
INSERT INTO YOUR_TABLE (the_string_column, ...) VALUES (:long_string, ...)