|
|
Posted by ZeldorBlat on 08/24/07 16:27
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.
Navigation:
[Reply to this message]
|