Maybe in the ODBC Datasource in CF change the long text buffer size from 65000 to 100000 in your case? Just spitballing from the top of my head....might solve the issue.
Regards, Eric J Hoffman DataStream Connexion -----Original Message----- From: JAAV [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 9:46 AM To: CF-Talk Subject: Limits to textarea? (II): No solutions? Hello, I have the same problem with w2k+MS SQL. I have a text field with 94000+ characters but when I try to do a query the DB returns me a 64.999 bytes (exactly) field. Any solutions to this issue? TIA Juan ----- Original Message ----- > From: "Russel Madere" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 14, 2002 8:59 PM > Subject: RE: Limits to textarea? > > > > Very interesting issue. > > > > Thanks for the info. I might give it a try on a Win 2K system with > > MS SQL > > to see if anything is different. In my copious spare time, of > > course. :) > > > > Russel > > > > -----Original Message----- > > From: Brian Scandale [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 14, 2002 11:41 AM > > To: CF-Talk > > Subject: RE: Limits to textarea? > > > > > > Hi Russel, > > > > I created a 10,000 character document with no spaces... > > 123456789012345678901234567890 etc... and cut and pasted it into the > > textarea box... > > > > After saving it I cut and pasted the result when querying it into > > msword > and > > then asked it to count the characters for me... 8194 was the > > answer. > > > > I then went to the database with another tool, (pgAdmin on NT > > against postgreSQL on a linux box), to find only 8194 characters. > > HOWEVER I was able to add more characters to the database vchar > > field via pgAdmin. So > it > > is not that the database can't, but rather I think that the CF > > server/postgreSQL ODBC driver combination can't. > > > > As an aside; it is interesting that 2^13 = 8192... And yes, 16 bits > > is 65536, the expected limitation. > > > > Brian > > > > > > > > At 10:34 AM 1/14/02 -0600, you wrote: > > >Out of curiousity, where are you getting the figure 8194? I have > > >seen > that > > >number as a character limit on the size of a single record in MS > > >SQL. > > > > > >Russel > > > > > >-----Original Message----- > > >From: Brian Scandale [mailto:[EMAIL PROTECTED]] > > >Sent: Monday, January 14, 2002 1:49 AM > > >To: CF-Talk > > >Subject: Limits to textarea? > > > > > > > > >Anyone know off hand what the limits are to a <textarea> are? > > > > > >I just tested and found 8194 characters maximum with the extra > > >being truncated. > > > > > >But... that was only one config in one browser etc... > > > > > >thanks, > > >Brian > > > > > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
