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 > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
