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]
