Home > Archive > PHP SQL > August 2007 > MAXIMUM LENGTH OF LONGTEXT FIELD
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MAXIMUM LENGTH OF LONGTEXT FIELD
|
|
| Richard 2007-08-24, 7:04 pm |
| 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
| |
| ZeldorBlat 2007-08-24, 7:04 pm |
| On Aug 24, 11:02 am, "Richard" <sa...@justmedals.com> 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: <a href="gohere.com/page1.html">GO HERE</a>
> 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.
|
|
|
|
|