Posted by Richard on 08/24/07 15:02

Hi all
Have been to the MySQL help pages trying to find out
how many characters (Latin set) I can load into a LONGTEXT
field. It tells me:
L characters + 4 bytes, where L < 232

Which I am afraid to say means nothing to me as a newbie user.
So, in plain english, how many normal characters/words will
the field accept and does a very long entry slow the search
down if the search is on other fields and not the LONGTEXT
field?

While I am here, a couple more questions please.
1. If I enter html code into a LONGTEXT field which is a
URL hotlink, does it show the link in the results as a clickable
hyperlink or does it show the HTML code as simple characters?

i.e. does it show: <a href="gohere.com/page1.html">GO HERE</a>
or does it correctly show GO HERE , clickable and hot

2. What are the pro's and con's of storing jpeg, gif images
within the table as binaries.

Many thanks

[Back to original message]