that's truncating it. By default it doesn't let BLOB or CLOBs through
greater than 65,000 bytes.
Cheers,
barneyb
> -----Original Message-----
> From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 07, 2004 1: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]
