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
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
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
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
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
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
.
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
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
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