'Character string truncated' error when importing CLOB via ODBC

Tools & Utilities
Enthusiast

'Character string truncated' error when importing CLOB via ODBC

Hi.

 

I'm using Teradata's Python module to import some data into a table (using INSERT INTO... VALUES (?,?) ).

 

When inserting into the CLOB column, however, I get the following error:

teradata.api.DatabaseError: (0, '[22001] [Teradata][ODBC Teradata Driver] Character string truncated')

This despite the fact that the CLOB column is defined with 100,000,000 characters, and the string I'm trying to import is only 1,000,000 ish.For small strings (around 50,000 characters), the upload into a CLOB column works correctly.

 

If I convert the string to a bytearray, then upload into a BLOB column, everything works as expected. 

 

Am I missing anything silly, or have I found a bug?