Gossamer Forum
Home : Products : Gossamer Links : Discussions :

TEXT or BLOB?

Quote Reply
TEXT or BLOB?
I want to create a form field where the user posts articles. Artcles are like 1000 to 15000 words.
So which one to use? Blob or Text?


If article can contain images, then it will change the 'Type'?


thanks.
Quote Reply
Re: [hegu] TEXT or BLOB? In reply to
Hi,

Personally, I'd probably go with TEXT.

Quote:
MySQL TEXT fields have a limit of 65,000 bytes.

..so that should be enough for what you need.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] TEXT or BLOB? In reply to
thanks Andy.

I did it. I want to integrate TinyMCE editor for this textarea ONLY in admin area where I add/modify links. Which template to edit? (Previously in Mint, there were browse_xxxxx.html files for admin area. But not in Luna?

Last edited by:

hegu: Apr 24, 2009, 9:05 AM
Quote Reply
Re: [hegu] TEXT or BLOB? In reply to
I think the templates you are looking for, are in the "browser" template set (you will need to access them via FTP, I believe)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!