Re: String Length Hard-Limit (NOT a RegEx question)

[Brendan Baldwin]

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]

---