Thread: [SQLObject] Declaring column type or large BLOB?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Darren G. <da...@on...> - 2008-11-13 14:06:09
|
Hi, I need to use a Large BLOB (the 'L' in blob), but SQLObject creates only a 'tinyblob' for BLOBCol in MySQL. Is there a way to tell SQLObject to make it a large blob? thanks, Darren |
From: Oleg B. <ph...@ph...> - 2008-11-13 14:21:26
|
On Thu, Nov 13, 2008 at 09:06:06AM -0500, Darren Govoni wrote: > I need to use a Large BLOB (the 'L' in blob), but SQLObject creates > only a 'tinyblob' for BLOBCol in MySQL. Is there a way to tell SQLObject > to make it a large blob? BLOBCol() - TINYBLOB BLOBCol(length=2**8) - BLOB BLOBCol(length=2**16) - MEDIUMBLOB BLOBCol(length=2**24) - LONGBLOB Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Dan P. <da...@ag...> - 2008-11-13 14:27:10
|
On Thursday 13 November 2008, Darren Govoni wrote: > Hi, > I need to use a Large BLOB (the 'L' in blob), but SQLObject creates > only a 'tinyblob' for BLOBCol in MySQL. Is there a way to tell > SQLObject to make it a large blob? Specify length=NNN to the column. Based on the size you specify it will create a tiny, medium or large blob. -- Dan |
From: Darren G. <da...@on...> - 2008-11-14 01:28:55
|
Ahh, cool. Thanks guys. On Thu, 2008-11-13 at 16:26 +0200, Dan Pascu wrote: > On Thursday 13 November 2008, Darren Govoni wrote: > > Hi, > > I need to use a Large BLOB (the 'L' in blob), but SQLObject creates > > only a 'tinyblob' for BLOBCol in MySQL. Is there a way to tell > > SQLObject to make it a large blob? > > Specify length=NNN to the column. Based on the size you specify it will > create a tiny, medium or large blob. > |