Need help regarding data types in mySQL

Asked By bella harwood 0 points N/A Posted on - 03/08/2012

Hi guys ,

I need your help to select the most appropriate data type in mysql to store a large body of textual information

• Status: Open
• Question Views: 1102
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Luker Malcom

Go To Solution

Answered By Howard william 0 points N/A #94436

Need help regarding data types in mySQL

Hi,

In mysql you can store data as your preferable size.  If your textual information within 64KB then you use “TEXT” attribute. If your  textual information is more than 64KB then you should use “MEDIUMTEXT”. If you have a very large textual information and you want to use it then use “LONGTEXT”. Hope your problem will be solved. Thanks

About Howard william

Questions
3

Answers
52

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Luker Malcom 5 points N/A #94437

Need help regarding data types in mySQL

Hi there. So you’re doing a blog or an informative website perhaps? If you’ve got a bulk of text information (character strings) that you want to store in mysql, then you can choose either of the following 2:

MEDIUMTEXT – this data type can hold up to 16,777,215 bytes (that’s 16 MB of characters)

LONGTEXT – this data type can hold up to 4,294,967,295 bytes (4 GB of characters)

In some cases, BLOB (Binary Large Objects) is used. BLOB types actually hold the same amount of bytes like TEXT but this is often used for binary such as images or files other than character strings. Hopefully my answer can help you decide.

About Luker Malcom

Questions
0

Answers
173

Best Answers
108

• Vote Up 0 Vote Down

• Posted on - 01/17/2013
• Question Category: MySQL Server