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 > > > > > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists