Gossamer Forum: Products: Gossamer Links: Discussions: TEXT or BLOB?

Apr 23, 2009, 12:31 PM

hegu

User (215 posts)

Apr 23, 2009, 12:31 PM

Post #1 of 4

Shortcut

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.

Apr 24, 2009, 12:42 AM

Andy

Veteran / Moderator (17298 posts)

Apr 24, 2009, 12:42 AM

Post #2 of 4

Shortcut

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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Apr 24, 2009, 8:53 AM

hegu

User (215 posts)

Apr 24, 2009, 8:53 AM

Post #3 of 4

Shortcut

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

Apr 24, 2009, 9:54 AM

Andy

Veteran / Moderator (17298 posts)

Apr 24, 2009, 9:54 AM

Post #4 of 4

Shortcut

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