My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 84: insert of long text fails silently
2 people starred this issue and may be notified of changes. Back to list
Status:  Complete
Owner:  ----
Closed:  Sep 2010


 
Reported by sc...@trevithick.ca, Jan 12, 2010
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.

puttydoc.txt
388 KB   View   Download
Aug 24, 2010
Project Member #1 mkleehammer
What is the target data type?  Make sure you are not exceeding SQL Server's maximum size for varchar columns (8000).  If you are not already, use a VARCHAR(MAX) (SQL Server 2008+) or text.

Status: Investigating
Sep 6, 2010
Project Member #2 mkleehammer
Fixed in 2.1.8.

Thanks.
Status: Fixed
Nov 21, 2010
Project Member #3 mkleehammer
(No comment was entered for this change.)
Status: Complete

Powered by Google Project Hosting