**
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: Monday, March 14, 2011 5:41 PM
To: cf-talk
Subject: RE: Data Truncation on TEXT field
Enable Blob/Clob on the datasoruce.
FYI, this is a public
Hi,
I have a client with no sense who want to type a book into a single field.
They have over 200,000 characters they are typing into the edit file.
Data base is:
MS SQL 2008 R2
Field type is:
text
When an update is done the data is truncated at around 63,000 characters.
Check the advanced settings on the datasource in the CF Adminstrator. Make
sure CLOB (Enable long text retrival) is checked , and increase the long
text buffer to handle the larger data field size.
~|
Order the Adobe
Going straight to just the SQL update I have:
cfquery datasource=#dsn#
UPDATE tbl_capabilities_categories
SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS'
WHERE id=#id#;
/cfquery
capability_cat_txt2 field type is TEXT
Only about 63,000 of the update characters are
: AW Unplugged
http://www.austin-williams.com/unplugged
-Original Message-
From: Brian Cain [mailto:bcc9...@gmail.com]
Sent: Monday, March 14, 2011 1:43 PM
To: cf-talk
Subject: Re: Data Truncation on TEXT field
Check the advanced settings on the datasource in the CF Adminstrator. Make
Rob,
The Text, NText, and Image data types come from the previous versions of SQL
Server. It is recommended that you use the newer varchar(MAX),
nvarchar(MAX), and varbinary(MAX) data types instead.
Results to text only allows a maximum of 8192 characters. Perhaps this is
also your issue in
[mailto:rob...@austin-williams.com]
Sent: Monday, March 14, 2011 1:39 PM
To: cf-talk
Subject: Data Truncation on TEXT field
Hi,
I have a client with no sense who want to type a book into a single field.
They have over 200,000 characters they are typing into the edit file.
Data base
Even the ones**
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: Monday, March 14, 2011 5:41 PM
To: cf-talk
Subject: RE: Data Truncation on TEXT field
Enable Blob/Clob
8 matches
Mail list logo