mal at lemburg.com
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.
CEO eGenix.com Software GmbH
Consulting & Company: http://www.egenix.com/
Python Software: http://www.lemburg.com/python/
More information about the Python-list