|
|
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
Navigation:
[Reply to this message]
|