64999 characters and then do an update on that row to append the rest of
the chars to the initial value in the DB. It's like duct tape, it might
not be pretty but it should work. (maybe) :-)
John
-----Original Message-----
From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 4:11 PM
To: CF-Talk
Subject: Re: String Length Hard-Limit (NOT a RegEx question)
Well I did some testing and CF handled gigantor strings (20 million
characters and more) without fail, even via form posts. but the sql
insert truncated all inserted strings down to 64999 characters.
I wonder if I could insert larger values using a stored procedure and
query params?
MS SQL documentation says that ntext columns can hold about a billion
unicode characters a pop-- i just dont know how to pop them in there
i didn't realize there were other limitations in the sql call itself.
but at least i know the exact upperbound for vanilla sql now. i'll just
throw on some client-side form validation to keep users from going over
the 64999 character limit until i do some more reading on the subject...
thanks for your help everybody! cf-talk is the best.
--brendan
>Ah, after Dave said 65k, made me think, isn't the datasource long text
>buffer size 65000 bytes by default? Could this be your issue?
>
>-----Original Message-----
>From: Craig Dudley
>Sent: 07 April 2004 17:02
>To: CF-Talk
>Subject: RE: String Length Hard-Limit (NOT a RegEx question)
>
>
>I suppose another possible culprit would be the datasource, have you
>enabled clobs? just a thought.
>
>-----Original Message-----
>From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
>Sent: 07 April 2004 16:57
>To: CF-Talk
>Subject: String Length Hard-Limit (NOT a RegEx question)
>
>Does CF have a hard-limit on number of characters for string variables?
>Do form posts from textareas themselves have a hard-limit? We have a
>database column of type nText which is truncating well before the
>(2^30)-1 character limit and I suspect an internal CF limit may be the
>culprit.
>
>Thanks!
>
>Brendan
> _____
> _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
