Setting varchar this large can adversely affect performance. Use text
instead.
-----Original Message-----
From: Chris Williams [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 4:26 PM
To: CF-Talk
Subject: RE: SQL question
Varchar can go to 8096.
-----Original Message-----
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 12:46 PM
To: CF-Talk
Subject: RE: SQL question
The limit of a 'text' data field is something like 2 Gigabytes, although
many drivers will cut it off at 64K unless you take precautions and set all
kinds of options. So your problem (at 1500 bytes) is not with the data type.
At 02:56 PM 10/30/00 -0500, Simon Horwith wrote:
>text is the datatype you want. I'm not sure what its limit is, but it's
far
>beyond 1500 characters. If you don't need to pass too much data, you could
>use varchar. I'm not sure what it's limit is, either, but I've used it to
>store up to 3,000 character fields without errors.
>
>~Simon
>
>-----Original Message-----
>From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
>Sent: Monday, October 30, 2000 2:52 PM
>To: CF-Talk
>Subject: Re: SQL question
>
>
>I'm positive it was truncated. I pulled the data directly out of SQL and
>over half of it is missing.
>
>
>
>----- Original Message -----
>From: "Simon Horwith" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, October 30, 2000 2:47 PM
>Subject: RE: SQL question
>
>
>> are you sure the value was truncated in the database, or might it be that
>> it's being truncated by Query Analyzer or Studio Query Builder, or
>whatever
>> youre using to view the data? Just checking... I've had that happen to
>me,
>> but have never had actual data loss before.
>>
>> ~Simon
>>
>> -----Original Message-----
>> From: Corina S. Moore [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, October 30, 2000 2:42 PM
>> To: CF-Talk
>> Subject: OT: SQL question
>>
>>
>> Hi List,
>> I am Learning SQL by trial and error. So far so good -- Until today.
>> I have a feedback form that captures comments. Currently I am using the
>> TEXT datatype in SQL. Today, a user entered a comment that was about
1500
>> characters long and the dB truncated the msg.
>> What datatype would be best for this situation?
>>
>> Thank You,
>>
>> Cori
>>
>>
>>
--------------------------------------------------------------------------
>--
>> --------------------
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a
>> message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>>
--------------------------------------------------------------------------
>----------------------
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>>
>
>
>---------------------------------------------------------------------------
-
>--------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>---------------------------------------------------------------------------
---------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
