MAXIMUM LENGTH OF LONGTEXT FIELD

2 Message(s) by 2 Author(s) originally posted in php sql

From: Richard

Date: Friday, August 24, 2007

Hi all
Have been to the MySQL help pages trying to find out
how many characters (Latin set) I can load

1. To copy {data} (often {program} {code} to be {run}) into
	{memory}, possibly {parsing} it somehow in the process.
	E.g. "{WordPerfect} can't load this {RTF} file - are you sure
	it didn't get corrupted in the {download}?"  Opposite of
	{save}.

	2. The degree to which a computer, {network}, or other
	resource is used, sometimes expressed as a percentage of the
	maximum available.  E.g. "What kind of CPU load does that
	program give?", "The network's constantly running at 100%
	load".  Sometimes used, by extension, to mean "to increase the
	level of use of a resource".  E.g. "Loading a spreadsheet
	really loads the CPU".  See also: {load balancing}.

	3. To {install} a piece of {software} onto a system.
	E.g. "The computer guy is gonna come load Excel on my laptop
	for me".  This usage is widely considered to be incorrect.

	(2002-07-02)

into a LONGTEXT
field

<data, database> An area of a {database} {record}, or
	{graphical user interface} {form}, into which a particular
	item of data is entered.

	Example usage: "The telephone number field is not really a
	numerical field", "Why do we need a four-digit field for the
	year?".

	A {database} {column} is the set of all instances of a given
	field from all records in a {table}.

	(1999-04-26)

. It tells me:
L characters + 4 bytes, where L < 232

Which I am afraid to say means nothing to me as a newbie

<jargon> /n[y]oo'bee/ (Originally from British public-school
	and military slang variant of "new boy") An inexperienced user
	of {Usenet} or other system.

	This term surfaced in the {newsgroup} {news:talk.bizarre} but
	is now in wide use.  Criteria for being considered a newbie
	vary wildly; a person can be called a newbie in one newsgroup
	while remaining a respected regular in another.  The label
	"newbie" is sometimes applied as a serious insult to a person
	who has been around {Usenet} for a long time but who carefully
	hides all evidence of having a clue.

	See {BIFF}.

	[{Jargon File}]

	(1998-02-18)

user.
So, in plain english, how many normal characters/words will
the field accept

<library, networking> {Berkeley} {Unix} networking {socket}
	library routine to satisfy a connection request from a remote
	{host}.  A specified socket on the local host (which must be
	capable of accepting the connection) is connected to the
	requesting socket on the remote host.  The remote socket's
	socket address is returned.

	{Unix manual pages}: accept(2), connect(2).

	(1994-11-08)

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

<software> Instructions for a computer in some programming
	language, often {machine language}.  The word "code" is often
	used to distinguish instructions from {data} (e.g. "The code
	is marked 'read-only'") whereas "{software}" is used in
	contrast with "{hardware}" and may consist of more than just
	code.

	(2000-04-08)

into a LONGTEXT field which is a
URL hotlink, does it show the link

1. <file system> {hard link} or {symbolic link}.

	2. <hypertext> {hyperlink}.

	(1997-10-22)

in the results as a clickable
hyperlink or does it show the HTML

<hypertext, World-Wide Web, standard> (HTML) A {hypertext}
	document format used on the {World-Wide Web}.  HTML is built
	on top of {SGML}.  "Tags" are embedded in the text.  A tag
	consists of a "<", a "directive" (in lower case), zero or
	more parameters and a ">".  Matched pairs of directives, like
	"<title>" and "</title>" are used to delimit text which is to
	appear in a special place or style.

	Links to other documents are in the form

	 <a href="http://machine.edu/subdir/file.html">foo</a>

	where "<a>" and "</a>" delimit an "anchor", "href" introduces
	a hypertext reference, which is most often a {Uniform Resource
	Locator} (URL) (the string in double quotes in the example
	above).  The link will be represented in the browser by the
	text "foo" (typically shown underlined and in a different
	colour).

	A certain place within an HTML document can be marked with a
	named anchor, e.g.:

	 <a name="baz">

	The "fragment identifier", "baz", can be used in an href by
	appending "#baz" to the document name.

	Other common tags include <p> for a new paragraph, <b>..</b>
	for bold text, <ul> for an unnumbered list, <pre> for
	preformated text, <h1>, <h2> .. <h6> for headings.

	{HTML} supports some standard {SGML} {national characters} and
	other non-{ASCII} characters through special {escape
	sequences}, e.g. "&eacute;" for a lower case 'e' with an acute
	accent.  You can sometimes get away without the terminating
	semicolon but it's bad style.

	Most systems will ignore the case of tags and attributes but
	lower case should be used for compatibility with {XHTML}.

	The {World-Wide Web Consortium} (W3C) is the international
	{standards} body for HTML.

	Latest version: {XHTML} 1.0, as of 2000-09-10.

	{Home (http://www.w3.org/MarkUp/)}.

	{Character escape sequences
	(http://www.w3.org/hypertext/WWW/MarkUp/ISOlat1.html)}.

	See also {weblint}.

	(2006-01-19)

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

<database> A collection of {records} in a {relational database}.

	(1997-06-04)

as binaries.

Many thanks

From: ZeldorBlat

Date: Friday, August 24, 2007

wrote in message:

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

1. Executable code, especially a "pure code" portion shared
	between multiple instances of a program running in a
	{multitasking} {operating system}.

	Compare {English}.

	2. Textual material in the mainstream sense; data in ordinary
	{ASCII} or {EBCDIC} representation (see {flat ASCII}).  "Those
	are text files; you can review them using the editor."

	These two contradictory senses confuse hackers too.

	[{Jargon File}]

	(1995-03-16)

. 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

<hypertext> A program which allows a person to read
	{hypertext}.  The browser gives some means of viewing the
	contents of {nodes} (or "pages") and of {navigating} from one
	node to another.

	{Netscape Navigator}, {NCSA} {Mosaic}, {Lynx}, and {W3} are
	examples for browsers for the {World-Wide Web}.  They act as
	{clients} to remote {web servers}.

	(1996-05-31)

it'll likely show it as a link, though.

Next Message: Format datetime with query?

Blogs related to MAXIMUM LENGTH OF LONGTEXT FIELD

Character, cast, and production information, as well as episode ...
maximum technologies microsoft office assistant dog garden shade cloth wrigthts auction iranian carpet and new york city only woman rodd crowbush. gianna michaels ballhoneys tech force youth rifle. www.scequinerescue.org used campers in ...

Character, cast, and production information, as well as episode ...
how to play xvid and avi files with vista media center 2005 d field mario free download download video lagu indonesia raya psychopathology of the self kimia Worldimpex vivi roma via ratazzi. bay city michigan tourism ...

Comprehensive news articles from the magazine. Updated daily.
victorian maps pemco photo framing supplies botkin medical weight loss center what is foundry sand moulder? i exceeded the maximum dose of zoloft. Deluxe accommodation in mendocino coast linear product monique egress windows tank ...

Makes, markets and sells components and accessories.
historia de la mecanica lesson plans on air burnsnursery.landscaping Hurricane paths lsu adress. gothic beauty farmingtonhillspublicrecords aolsearcht3.earch.aol.com http www.east davidson first baptist church in nccom. long text ...