Re: [cfaussie] OT : SQL TEXT type column
SQLSVR2009? You Mean 2010 right? Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On Fri, Oct 15, 2010 at 15:54, Gavin Beau Baumanis b...@palcare.com.auwrote: Hi Steve from; http://msdn.microsoft.com/en-us/library/ms143432.aspx Database size : 524,272 terabytes Databases per instance of SQL Server : 32,767 Bytes per varchar(max), varbinary(max), xml, text, or image column : 2^31-1 Bytes per row (*) : 8,060 (*) SQL Server supports row-overflow storage which enables variable length columns to be pushed off-row. Only a 24-byte root is stored in the main record for variable length columns pushed out of row; because of this, the effective row limit is higher than in previous releases of SQL Server. For more information, see the Row-Overflow Data Exceeding 8 KB topic in SQL Server Books Online. As always, please contact me if I can be of any futher assistance. Gavin Beau Baumanis Senior Application Developer PalCare Pty. Ltd. P: +61 -3 9380 3513 M: +61 -438 545 586 E: b...@palcare.com.au W: http://palcare.com.au On 15/10/2010, at 3:36 PM, Steve Onnis wrote: 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.comhttp://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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] OT : SQL TEXT type column
Also don't use text use varchar(max) as SQL Server is depreciating text. http://technet.microsoft.com/en-us/library/ms189087.aspx Paul On 15/10/2010 5:31 PM, Peter Tilbrook wrote: SQLSVR2009? You Mean 2010 right? Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com mailto:pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On Fri, Oct 15, 2010 at 15:54, Gavin Beau Baumanis b...@palcare.com.au mailto:b...@palcare.com.au wrote: Hi Steve from; http://msdn.microsoft.com/en-us/library/ms143432.aspx Database size : 524,272 terabytes Databases per instance of SQL Server : 32,767 Bytes per varchar(max), varbinary(max), xml, text, or image column : 2^31-1 Bytes per row (*) : 8,060 (*) SQL Server supports row-overflow storage which enables variable length columns to be pushed off-row. Only a 24-byte root is stored in the main record for variable length columns pushed out of row; because of this, the effective row limit is higher than in previous releases of SQL Server. For more information, see the Row-Overflow Data Exceeding 8 KB topic in SQL Server Books Online. As always, please contact me if I can be of any futher assistance. Gavin Beau Baumanis Senior Application Developer PalCare Pty. Ltd. P: +61 -3 9380 3513 M: +61 -438 545 586 E: b...@palcare.com.au mailto:b...@palcare.com.au W: http://palcare.com.au On 15/10/2010, at 3:36 PM, Steve Onnis wrote: 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 cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie+unsubscr...@googlegroups.com. 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 cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
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: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: cfaussie@googlegroups.com 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.comhttp://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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] OT : SQL TEXT type column
This is on CF8 ENT and MSSQL2008 From: Adam chapman [mailto:a...@portplus.com] Sent: Friday, 15 October 2010 3:42 PM To: cfaussie@googlegroups.com 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: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: cfaussie@googlegroups.com 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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/ === -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] OT : SQL TEXT type column
On Thu, Oct 14, 2010 at 9:36 PM, Steve Onnis st...@cfcentral.com.au wrote: How much can this column actually hold? Depends on which database you are referring to - and which version. 2.1 billion bytes is possible - I think for MS SQL Server? Oracle's CLOB could hold 4GB and that's increased in recent versions. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
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:a...@portplus.com] Sent: Friday, 15 October 2010 3:42 PM To: cfaussie@googlegroups.com 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: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: cfaussie@googlegroups.com 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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/ === -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] OT : SQL TEXT type column
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: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:47 PM To: cfaussie@googlegroups.com 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:a...@portplus.com] Sent: Friday, 15 October 2010 3:42 PM To: cfaussie@googlegroups.com 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: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: cfaussie@googlegroups.com 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.comhttp://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 cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto:cfaussie+unsubscr...@googlegroups.com. 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 cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto:cfaussie+unsubscr...@googlegroups.com. 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.comhttp://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.comhttp://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 cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto:cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] OT : SQL TEXT type column
You might already bea aware of this and I'm not sure about MSSQL but in the setup for mySQL datasources in CF admin you have to explicity enable CLOB and/or BLOB support before it will actually return the full content of a TEXT field. B) On 15/10/2010 12:36 PM, Steve Onnis wrote: 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.862 / Virus Database: 271.1.1/3197 - Release Date: 10/15/10 02:34:00 -- Brett Payne-Rhodes YourSite Web Solutions w: http://www.yoursite.net.au e: br...@ehc.net.au t: +61 (0)8 9371-0471 m: +61 (0)414 371 047 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] OT : SQL TEXT type column
Hi Steve from; http://msdn.microsoft.com/en-us/library/ms143432.aspx Database size : 524,272 terabytes Databases per instance of SQL Server : 32,767 Bytes per varchar(max), varbinary(max), xml, text, or image column : 2^31-1 Bytes per row (*) : 8,060 (*) SQL Server supports row-overflow storage which enables variable length columns to be pushed off-row. Only a 24-byte root is stored in the main record for variable length columns pushed out of row; because of this, the effective row limit is higher than in previous releases of SQL Server. For more information, see the Row-Overflow Data Exceeding 8 KB topic in SQL Server Books Online. As always, please contact me if I can be of any futher assistance. Gavin Beau Baumanis Senior Application Developer PalCare Pty. Ltd. P: +61 -3 9380 3513 M: +61 -438 545 586 E: b...@palcare.com.au W: http://palcare.com.au On 15/10/2010, at 3:36 PM, Steve Onnis wrote: 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 === -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.