RE: CF 4.5 64K database field limit

[Brandon McMurray]

Title: 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]