varbinary insert/update failure to SQL Server in Python 3

[GoogleCodeExporter]

Code Snippet:

cur.execute("create table TEST ( name varchar(30), record varbinary(max) )")
cur.commit()

data = bytearray()
for i in range(10):
    for b in range(256):
        data.append(b)
        print(len(data))
        cur.execute("insert into TEST values (?, ?)", ('foo' + str(i*256+b), data))

Code works fine running in 2.7, but fails in 3.3:
pypyodbc.DataError: ('22001', '[22001] [Microsoft][SQL Server Native Client 
11.0]String data, right truncation')

Running on Win7 with 64bit python against SQL Server 2012.
Problem was originally discovered when trying to store gzip data blobs in a 
varbinary(max) column.

Original issue reported on code.google.com by adamson....@gmail.com on 11 Jan 2014 at 6:19

[GoogleCodeExporter]

Attached is the new release should fix your problem. Will be released very 
soon. Please see if that works for you.

Original comment by jiangwen...@gmail.com on 12 Feb 2014 at 2:54

Attachments:

• pypyodbc-1.3.0.zip

[GoogleCodeExporter]

Original comment by jiangwen...@gmail.com on 12 Feb 2014 at 2:54

• Changed state: Accepted

[GoogleCodeExporter]

This corrects the problem.

Original comment by adamson....@gmail.com on 13 Feb 2014 at 3:32

[GoogleCodeExporter]

Original comment by jiangwen...@gmail.com on 15 Feb 2014 at 6:28

• Changed state: Fixed