You say uploading don't works? What is you web server? Nginx were having a
bug and limit the size of the file...
Also, why you want to put your file in blob... I am going away from that,
it bloat database and make db dump longer, etc.
Richard
On Tue, Feb 10, 2015 at 10:24 AM, Jose <jjac...@gmail.com> wrote:
> Hello everyone
>
> I have the following:
>
> Web2py on Freebsd.
> Database: SQLServer 2008
>
> Connection: web2py <-> pyodbc <-> UnixODBC <-> FreeTDS <-> SQLServer
>
> I'm trying to store some uploaded files into a blob field, instead than on
> the file system.
>
> The table was created by the administrator SQLServer
>
> CREATE TABLE [dbo].[DocumentosBlob](
> [Id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
> [Nombre] [varchar](50) NULL,
> [Archivo] [varchar](512) NULL,
> [Archivo_Blob] [text] NULL,
> [Archivo_Blob2] [image] NULL
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>
>
>
>
> The adapter defines SQLServer blob fields as IMAGE ('blob': 'IMAGE',).
> Then use for testing the Archivo_Blob2 field is set to IMAGE
> In my model I have:
>
> tb_documentos_blob = db.define_table('DocumentosBlob',
> Field('nombre', length=50),
> Field('archivo', 'upload', uploadfield='archivo_blob2'),
> Field('archivo_blob2', 'blob', writable=False, readable=False),
> migrate=False,
> )
>
>
>
> But it happens that when trying to upload a file upload the following
> error occurs:
>
> *DataError: ('22018', '[22018] [FreeTDS][SQL Server]Operand type clash:
> text is incompatible with image (206) (SQLExecDirectW)')*
>
> Then I changed the field, using one type TEXT (Archivo_Blob). The model
> will now be:
>
> tb_documentos_blob = db.define_table('DocumentosBlob',
> Field('nombre', length=50),
> Field('archivo', 'upload', uploadfield='archivo_blob'),
> Field('archivo_blob', 'blob', writable=False, readable=False),
> migrate=False,
> )
>
>
>
> Now it works, I can upload and download files, but only with very small
> files. Tested with 20KB. With one of 250KB upload it, but at download it is
> broken. I imagine that was truncated when stored in the database.
>
> How I can fix this?
>
> Best Regards
> José
>
> --
> 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.
>
--
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.
