¡@

Home 

python Programming Glossary: textsize

using pyodbc on ubuntu to insert a image field on SQL Server

http://stackoverflow.com/questions/1060035/using-pyodbc-on-ubuntu-to-insert-a-image-field-on-sql-server

bounty I've found out the solution. You have to use SET TEXTSIZE 2147483647 on the query in addition of text size configuration.. in etc freetds freetds.conf . I have used cur.execute 'SET TEXTSIZE 2147483647 SELECT myimage FROM testing WHERE id 1' And everything.. about the text size configuration option default value of TEXTSIZE in bytes. For text and image datatypes sets the maximum width..

Python with MS SQL - truncated output

http://stackoverflow.com/questions/11882910/python-with-ms-sql-truncated-output

tds version 8.0 text size 4294967295 Also have to set TEXTSIZE in SQL to maximum 2147483647 bytes sql SET TEXTSIZE 2147483647.. to set TEXTSIZE in SQL to maximum 2147483647 bytes sql SET TEXTSIZE 2147483647 SELECT Req.ID ShReq.Summary AS Short Name ShReq.ALM_SharedText..