2,147,483,647 characters in MSSQL 2009. Your insert/update queries will error if the length exceeds that specified in cfadmin... you could try increasing if to MSSQL maximum.. I have not tried that!
http://msdn.microsoft.com/en-us/library/ms187993.aspx See the note regarding deprecation of the text datatype. Important ntext, text, and image data types will be removed in a future version of MicrosoftSQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. Regards, Adam From: [email protected] [mailto:[email protected]] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:47 PM To: [email protected] Subject: RE: [cfaussie] OT : SQL TEXT type column It has Long Text Buffer (chr) : 64000 Does that means it will truncate at that? What if i don't want to restrict it at all? From: Adam chapman [mailto:[email protected]] Sent: Friday, 15 October 2010 3:42 PM To: [email protected] Subject: RE: [cfaussie] OT : SQL TEXT type column Hi Steve, Depending on your database, the TEXT datatype column can handle LARGE amounts of data. You might want to check how much data your datasource can handle.. check out the Advanced Settings in your datasource in cfadmin. Regards, Adam From: [email protected] [mailto:[email protected]] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: [email protected] Subject: [cfaussie] OT : SQL TEXT type column How much can this column actually hold? How would it translate to say a text file in size? I am trying to work out if a heap of data should be able to fit into the column or not ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) http://www.pctools.com<http://www.pctools.com/?cclick=EmailFooterClean_51> ======= -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]<mailto:[email protected]>. To unsubscribe from this group, send email to [email protected]<mailto:[email protected]>. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]<mailto:[email protected]>. To unsubscribe from this group, send email to [email protected]<mailto:[email protected]>. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) http://www.pctools.com<http://www.pctools.com/?cclick=EmailFooterClean_51> ======= ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) http://www.pctools.com<http://www.pctools.com/?cclick=EmailFooterClean_51> ======= -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]<mailto:[email protected]>. To unsubscribe from this group, send email to [email protected]<mailto:[email protected]>. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
