when must we use LONGTEXT type in MYSQL?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Mds
Forum Contributor
Posts: 110
Joined: Tue Apr 22, 2008 8:56 pm
Contact:

when must we use LONGTEXT type in MYSQL?

Post by Mds »

Hi there.

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

Thanks in advance.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: when must we use LONGTEXT type in MYSQL?

Post by Benjamin »

When you need to store between 16777215 and 4294967295 characters or bytes of binary data.
User avatar
Mds
Forum Contributor
Posts: 110
Joined: Tue Apr 22, 2008 8:56 pm
Contact:

Re: when must we use LONGTEXT type in MYSQL?

Post by Mds »

I want to create a field for news context (for news website).
What does your suggest ?
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: when must we use LONGTEXT type in MYSQL?

Post by Benjamin »

Here, have a look:

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

I would probably use a BLOB.
User avatar
Mds
Forum Contributor
Posts: 110
Joined: Tue Apr 22, 2008 8:56 pm
Contact:

Re: when must we use LONGTEXT type in MYSQL?

Post by Mds »

OK. Thanks.
Post Reply