Thread: [SQLObject] StringCol() only saving 64k

SQLObject is a Python ORM.

Brought to you by: ianbicking, phd

sqlobject-discuss

[SQLObject] StringCol() only saving 64k

From: David M. <da...@re...> - 2004-03-01 14:17:45

Hi,

I'm trying to save a fat wad of data in a StringCol column, but only the 
first 65536 chars are getting saved.

Is this a MySQL restriction, or something in SQLObject?

Either way, is there a way around this?

-- 

Kind regards
David

--

leave this line intact so your email gets through my junk mail filter

[SQLObject] Re: StringCol() only saving 64k

From: Chris G. <ch...@il...> - 2004-03-02 02:53:20

"David McNab" <da...@re...> wrote in message
news:404...@re......
> I'm trying to save a fat wad of data in a StringCol column, but only the
> first 65536 chars are getting saved.
>
> Is this a MySQL restriction, or something in SQLObject?
>
> Either way, is there a way around this?

I think the best thing to do is NOT use the database to store chunks of data
that big. It can be pretty inefficient with a large table. Writing to the
file system is best.

This doesn't mean you have to stop using SQLObject though! :) SQLObject lets
you add your own functions that get called when a user tries to access an
SQLObject attribute (or any python object, for that matter...).

I think that's probably the best way to do it. Of course, I don't know what
you're trying to do... so take it with a grain of salt.

Here's how you use magic attributes:


http://sqlobject.org/docs/SQLObject.html#adding-magic-attributes-properties

Enjoy!

Re: [SQLObject] StringCol() only saving 64k

From: Ian B. <ia...@co...> - 2004-03-02 06:55:33

On Mar 1, 2004, at 8:05 AM, David McNab wrote:
> I'm trying to save a fat wad of data in a StringCol column, but only 
> the first 65536 chars are getting saved.
>
> Is this a MySQL restriction, or something in SQLObject?

That's a MySQL restriction (I'd guess -- certainly not SQLObject).  You 
might have better luck with a BLOB column (as opposed to TEXT).

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org

Re: [SQLObject] StringCol() only saving 64k

From: Oleg B. <ph...@ma...> - 2004-03-02 09:55:57

On Tue, Mar 02, 2004 at 12:42:54AM -0600, Ian Bicking wrote:
> On Mar 1, 2004, at 8:05 AM, David McNab wrote:
> >I'm trying to save a fat wad of data in a StringCol column, but only 
> >the first 65536 chars are getting saved.
> >
> >Is this a MySQL restriction, or something in SQLObject?
> 
> That's a MySQL restriction (I'd guess -- certainly not SQLObject).  You 
> might have better luck with a BLOB column (as opposed to TEXT).

   Not neccessary. Just use MEDUIMTEXT, or LONGTEXT. Or MEDIUMBLOB or
LOBGBLOB.
   But always look into docs. That 65535 bytes is described there.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.