Actually, the total width of a table is 8060. Check in SQL BOL for Data
Types...in the meantime, char and varchar can hold 8000 characters total,
and text can hold 2 ^ 31 - 1 characters (it is stored like a BLOB or a memo
field in Access - a pointer to the actual data is stored in the table)
You can use TEXT as your data type, but you may find some problems at some
point when accessing the data. In some cases you much place the TEXT fields
at the end of your SQL Statement in order to be retrievable (older versions
of ADO) but you probably won't have a problem in ColdFusion.
hth....
David L. Penton
"Mathematics is music for the mind, and Music is Mathematics for the
Soul." - J.S. Bach
[EMAIL PROTECTED]
"If you want an ISP with great Network
connectivity and great email,
DON'T use AT&T @Home"
-----Original Message-----
From: Palyne Gaenir
Thanks David, I think I see -- so when you create a table in SQL
Server you cannot have columns of CHAR-types that total more than
8000 chars or so. I didn't know that! I revised a few varchar(4000)
to TEXT fields... wait a minute... there were three 4000 varchars in
the original table, how come it didn't say anything on creation?
What would happen if I had that situation in some other table --
could it cause something like, for example, a long textarea
submission to simply 'cut off' when sent? Do you know if I am
suffering serious performance issues by using TEXT instead of
varchar?
Also... I thought this db varchar only allowed 4000 chars. Has it
enlarged? 20 questions!! I'm sorry. Only if you've time of course.
Best Regards,
Palyne
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
