MySQL field type for a comments field or text area

mysql field longtext
Yvonne picture Yvonne · Mar 18, 2010 · Viewed 7.5k times · Source

As the title says, I'm after a good field type for a comments field I have in a table. It will store many characters (as users can continuously add to it) so it's definitely over 255. I looked at longtext but wasn't sure...Also how do I change the field type to accept different characters such as apostrophies. Thanks.

Answer

Dean Harding picture Dean Harding · Mar 18, 2010

LONGTEXT is what you want (maybe even MEDIUMTEXT or just TEXT depending on the maximum length of text you're expecting: TEXT can store up to 65KB of text, which is usually more than enough.

All of these fields can store UTF-8 encoded Unicode, so I'm not sure what you mean by the second part of your question (about apostrophies).

Related questions

How to remove leading and trailing whitespace in a MySQL field?

I have a table with two fields (countries and ISO codes): Table1 field1 - e.g. 'Afghanistan' (without quotes) field2 - e.g. 'AF'(without quotes) In some rows the second field has whitespace at the start and/or end, …

Read More
Mysql Compare two datetime fields

I want to compare two dates with time, I want all the results from tbl where date1 > date2 Select * From temp where mydate > '2009-06-29 04:00:44'; but it is just comparing dates not time. it is giving …

Read More
IP address storing in MySQL database using PHP

what is the right field type for IP address in mysql? and what is the right way of storing it using PHP?

Read More