OT : SQL TEXT type column

[Steve Onnis]

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

[Adam chapman]

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

--
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfau...@googlegroups.com.
To unsubscribe from this group, send email to cfaussie+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.

[Steve Onnis]

This is on CF8 ENT and MSSQL2008

[Sean Corfield]

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

[Steve Onnis]

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:Ad...@portplus.com]

Sent: Friday, 15 October 2010 3:42 PM
To: cfau...@googlegroups.com

[Adam chapman]

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.

[Brett Payne-Rhodes]

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)

> 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 cfau...@googlegroups.com.
> To unsubscribe from this group, send email to cfaussie+u...@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

[Gavin Beau Baumanis]

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: be...@palcare.com.au
W: http://palcare.com.au

[Peter Tilbrook]

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

[Paul Kukiel]

Also don't use text use varchar(max) as SQL Server is depreciating text.

http://technet.microsoft.com/en-us/library/ms189087.aspx

Paul