Disadvantages to using "text"

by dmies@[EMAIL PROTECTED] ("Don Mies (NIM)") May 7, 2008 at 08:52 AM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C8B05A.59CB8B62
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Are there any reasons for not using the "text" type whenever a variable
length string field is needed?  Are there penalties in disk usage,
memory usage or performance?

=20

What are the differences between declaring something "varchar" or
"varchar(n)" or "text"?  (I realize that the middle one has an upper
limit while the others do not.)

=20

=20

Don

=20

=20


------_=_NextPart_001_01C8B05A.59CB8B62
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@[EMAIL PROTECTED]
 Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Are there any reasons for not using the =
&#8220;text&#8221;
type whenever a variable length string field is needed?&nbsp; Are there =
penalties in
disk usage, memory usage or performance?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>What are the differences between declaring something =
&#8220;varchar&#8221;
or &#8220;varchar(n)&#8221; or &#8220;text&#8221;?&nbsp; (I realize that =
the middle
one has an upper limit while the others do =
not.)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Don</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;</span><o:p></o:p></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C8B05A.59CB8B62--

15 Posts in Topic:

Disadvantages to using "text"

dmies@[EMAIL PROTECTED]

2008-05-07 08:52:27

Re: Disadvantages to using "text"

rdeleonp@[EMAIL PROTECTED

2008-05-07 11:01:09

Re: Disadvantages to using "text"

richard.broersma@[EMAIL P

2008-05-07 09:03:57

Re: Disadvantages to using "text"

tgl@[EMAIL PROTECTED] (T