Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Firebird Adapter can't insert blobs greater than 64kb #666

Closed
niphlod opened this issue Jan 26, 2015 · 1 comment
Closed

Firebird Adapter can't insert blobs greater than 64kb #666

niphlod opened this issue Jan 26, 2015 · 1 comment

Comments

@niphlod
Copy link
Member

niphlod commented Jan 26, 2015

From r..._at_tarkus.mx on July 03, 2013 00:30:23

What steps will reproduce the problem? 1.- Define a table containing a blob field
2.- Try to insert or update a row assigning that field data > 64kb What is the expected output? What do you see instead? It's expected that the field will contain the data assigned, just as it functions when the data < 64kb What version of the product are you using? On what operating system? Using web2py 2.5.1, fdb 1.4 Please provide any additional information below. This occurs because Firebird has a 64kb limit on the size of parameters. According to fdb documentation, a blob parameter has to be manipulated as a file-like object.
cur.execute("insert into blob_test values (?)", (StringIO('abcdef'),))

Original issue: http://code.google.com/p/web2py/issues/detail?id=1571

@niphlod
Copy link
Member Author

niphlod commented Oct 13, 2015

track the progress on web2py/pydal#155 . Until that is fixed, there's no way around it.

@niphlod niphlod closed this as completed Oct 13, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants