Page 1 of 1

when must we use LONGTEXT type in MYSQL?

Posted: Wed Jul 09, 2008 11:41 am
by Mds
Hi there.

Do you know when we must use LONGTEXT type in MYSQL? :?:

Thanks in advance.

Re: when must we use LONGTEXT type in MYSQL?

Posted: Wed Jul 09, 2008 3:41 pm
by Benjamin
When you need to store between 16777215 and 4294967295 characters or bytes of binary data.

Re: when must we use LONGTEXT type in MYSQL?

Posted: Thu Jul 10, 2008 7:42 am
by Mds
I want to create a field for news context (for news website).
What does your suggest ?

Re: when must we use LONGTEXT type in MYSQL?

Posted: Thu Jul 10, 2008 12:12 pm
by Benjamin
Here, have a look:

http://help.scibit.com/Mascon/masconMyS ... Types.html

I would probably use a BLOB.

Re: when must we use LONGTEXT type in MYSQL?

Posted: Thu Jul 10, 2008 2:42 pm
by Mds
OK. Thanks.