| Issue 84: | insert of long text fails silently | |
| 2 people starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem? 1. Read a 400KB text document into a Python string 2. execute an SQL Insert statement that inserts the string into an SQL Server text field 3. commit the transaction What is the expected output? What do you see instead? The string should be inserted into the text field. Instead, nothing is inserted but no error is raised. Other values in the same Insert statement are properly inserted and a new row is created. What version of the product are you using? On what operating system? Windows 7; pyodbc 2.1.6 for Python 2.6; SQL Server Express 2005 Please provide any additional information below. The same test script works perfectly on a Windows 2003 server with SQL Server 2005 (i.e., not the Express version) but fails with Windows 7 and SQL Server Express 2005. I have attached the document which I used for testing, the documentation for PuTTY. Smaller strings are inserted properly, but I do not know at what size of string the issue appears.
Aug 24, 2010
Project Member
#1
mkleehammer
Status:
Investigating
Sep 6, 2010
Fixed in 2.1.8. Thanks.
Status:
Fixed
Nov 21, 2010
(No comment was entered for this change.)
Status:
Complete
|