MAXIMUM LENGTH OF LONGTEXT FIELD

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:
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

Re: MAXIMUM LENGTH OF LONGTEXT FIELD

On Aug 24, 11:02 am, "Richard" wrote:
> 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?

2^32 characters. Which is 4,294,967,296 bytes or 4 GB.

>
> 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:
> or does it correctly show GO HERE , clickable and hot

Text is text. MySQL knows nothing about HTML or how to interpret it.
What you put in is what you get out. If you take that text and look
at it in a browser it will likely show it as a link, though.