you're correct. web2py handles blob types and 'upload' Fields in its own
way. You'd have to resort to either a full migration to another table or to
access the data using "raw" sql statements.
On Saturday, June 13, 2015 at 5:20:06 AM UTC+2, Viktor Boiarchuk wrote:
>
> Hello everybody!
> Nice to meet so excellent community.
>
> My problem is next. I'm trying to use web2py with *external* sqlite
> database formed by another program. One of the column of those database
> consists of binary data of pdf docs. So I defined that field in model
> *Field('pdf_binary','blob')*. I'm using SQLFORM.grid to modify my table
> (not blob column). When I submit changes they are accepted but data in
> 'pdf_binary' become corrupted (it seems it has just begging of file data).
>
> Moreover when I try to extract binary data from blob field I also get just
> part of data, but when I change field type to 'text' for e.g. ,
> *Field('pdf_binary','text')* I can extract normal data, but in this case
> I get "the query contains a null character" error when i try to submit
> changes in SQLFORM.
> I can't use upload field, because my binaries was made by another program
> and it also raises errors when updating db.
> It seems that blob type is right choice for my aims, but it doesn't worked
> I predicted.
>
> I will be thankful for all advices.
> Regard
> Viktor
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
