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

Reply via email to