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/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
