Re: [SQLObject] SQL Server varchar(4000) instead of TEXT

[Davide A. <dav...@gm...>]

2007/10/12, Oleg Broytmann <ph...@ph...>:
>
>
>    Thank you. I will put that "(MAX)" into the code. Also I thing I need
> to
> replace "IMAGE" type for BLOBCol with "VARCHAR(MAX)".


I think "VARBINARY(MAX)" would be a better choice.
Usual disclaimer: I've never directly used MS SQL Server/SQLExpress, so I
don't really know how well it will work; if anyone has direct experience,
please report. :-)
Moreover, I suppose these "MAX" types will break compatibility with versions
older than SQL Server  2005; I don't know if there's a better way to
implement support for this types of columns, sorry.


Thanks!
-- 
Davide Alberani <dav...@gm...>  [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/