In Sybase varchar can only go to 255 characters.
At 01:26 PM 10/30/00 -0800, Chris Williams wrote:
>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/[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]
>
>
>
>---------------------------------------------------------------------------
>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/[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]
---------------------------------------------------------------------------
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
