[web2py] Re: BLOB fields in MSSQL Server

2015-02-12 Thread Niphlod
no problem. mssql is to blame for some things, but this is definitely not one of them ^_^ On Thursday, February 12, 2015 at 10:38:55 PM UTC+1, Jose wrote: > > SOLVED. > > I changed the "text size" of the connection, the configuration of FreeTDS > (freetds.conf). > I tried with large files and it

[web2py] Re: BLOB fields in MSSQL Server

2015-02-12 Thread Jose
SOLVED. I changed the "text size" of the connection, the configuration of FreeTDS ( freetds.conf). I tried with large files and it works great Thank you very much for the help -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source co

[web2py] Re: BLOB fields in MSSQL Server

2015-02-12 Thread Jose
> > this model is correctly tied to the underlying structure (and web2py > "conventions"). Read my previous post on TEXTSIZE setting throughout your > middlewares. > OK, I'm going to try. Thank You -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] Re: BLOB fields in MSSQL Server

2015-02-11 Thread Niphlod
> 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)')* > This is perfectly fine. web2py adopts a convention that simplifies t

[web2py] Re: BLOB fields in MSSQL Server

2015-02-11 Thread Niphlod
this has nothing to do with the aforementioned error (operand type clash). In addition to that, TEXTSIZE just limits what a text, image, varbinary, varchar field is allowed to be fetched, not stored. Since web2py is using odbc, and odbc uses the max limit that you mention by default, if you're

[web2py] Re: BLOB fields in MSSQL Server

2015-02-10 Thread Raul Monares
I had a similar problem with truncated info in blob fields. This line fixed for me: db.executesql('SET TEXTSIZE 2147483647') right after the DAL connection On Tuesday, February 10, 2015 at 8:24:19 AM UTC-7, Jose wrote: > > Hello everyone > > I have the following: > > Web2py on Freebsd. > Da