M.-A. Lemburg mal at
Mon Oct 22 13:20:43 CEST 2001

Ben C wrote:
> Hi there,
> I am pushing text data to a MS SQL Server DB using the mxODBC module
> which seems to work fine ... most of the time. One of the columns I am
> pushing this text to has the data type set to Text. However ... I am
> getting data truncation when attempting to upload some largish strings
> ~ 14kb ... the Text datatype should handle 2 gigabytes of data ... the
> warning message is as follows
> Warning: ('22001', 0, '[Microsoft][ODBC SQL Server Driver]String data,
> right truncation', 4490)
> Would this have something to do with a buffer size setting?
> any suggestions most appreciated..

This could be a problem with the network buffer size used by the 
ODBC driver. Please check the MSDN for possible workarounds or
how to increase the buffer size.

Marc-Andre Lemburg
CEO Software GmbH
Consulting & Company:                 
Python Software:              

More information about the Python-list mailing list