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]
