I'd say make sure that you have the latest postgreSQL ODBC drivers on both your server and your development box. My co-worker passed this info along to me a while ago
"the new ODBC driver will allow huge text inserts and selects which previously were hindered to like 8k (bump the max longvarchar size in the odbc setting to 0 for unlimited length. you can also bump up the block size of your postgresql database by pushing it from 8194 to 32768 (include/config.h change the setting and recompile) to handle large amounts of text. all of this i just went through to get cf running well with it. :) " Hope that helps, t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 9: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 Your Own 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=coldfusionb 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
