RE: CF 4.5 64K database field limit

[Phillip B. Holmes]

Title: CF 4.5 64K database field limit

Best thing to do is write a batch file and put it on the AT that stops and restarts CF server @ a late hour.   Respectfully,   <cf_developer> Phillip B. Holmes Media Resolutions Inc. Macromedia Alliance Partner http://www.mediares.com [EMAIL PROTECTED] 1-888-395-4678 ext. 101 972-889-0201 ext. 101 </cf_developer>   Please send support requests to [EMAIL PROTECTED]   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Schreck, Tom Sent: Tuesday, May 21, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: RE: CF 4.5 64K database field limit   Yep, you need both and restart cf server   Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison   -----Original Message----- From: Brandon McMurray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:22 AM To: '[EMAIL PROTECTED]' Subject: RE: CF 4.5 64K database field limit   Thanks Tom.   I tried first setting the buffer size to 650000 (adding a 0), but that didn't work for me.  I then enabled the option "Enable retrieval of long text" and that worked.   -Brandon   -----Original Message----- From: Schreck, Tom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:41 AM To: [EMAIL PROTECTED] Subject: RE: CF 4.5 64K database field limit It’s a limitation of your ODBC Data Source setting.  Go to your CF administrator, select ODBC Data Sources.  Select your Data Source Name you wish to edit.  Select CF Setting.  Check the “Enable retrieval of long text” check box then set the Long Text Buffer Size box to a number you think will accommodate your data size.  It defaults to 65000.  I’ve added an extra 0 and have had no problems.  For this to work, you will have to stop and restart cf.  Hope this helps.   Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison   -----Original Message----- From: Brandon McMurray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:29 AM To: '[EMAIL PROTECTED]' Subject: CF 4.5 64K database field limit   Hello - There appears to be a 64k limit on database field size in CF 4.5.  I have a Text field that gets truncated to 64k every time I try to insert data via CF.  I can insert data directly from the database interface, or via Perl DBI, neither of which get truncated.  Is this a known issue with 4.5?  Is the same issue present in 5.0? I am using CF 4.5 on Solaris 2.6 with SyBase ASA 7. Thanks in advance for your help. -Brandon -- Brandon McMurray Web Developer / Admin Dallas Semiconductor Corp [EMAIL PROTECTED]