CF_SQL_LONGVARCHAR is mapped to the Oracle LONG datatype, which should hold 2 gigs but was deprecated in 8i, I think. (I know for certain that the LONG datatype is deprecated in Oracle9i, which is what I use.) CF_SQL_LONGVARCHAR is mapped to the NTEXT datatype in MSSQL, but I know next to nothing about MSSQL :). CF_SQL_CLOB maps to the Oracle CLOB datatype, which should hold up to 4 gigs, but is not applicable to MSSQL.
FarCry uses CF_SQL_LONGVARCHAR to update data in CLOB columns, which seems to work, but I think Beth may have found a limitation. It would probably be better to use the CF_SQL_CLOB datatype for Oracle. FYI, Sam Neff put together a very helpful chart detailing what CF_SQL_TYPES map to in specific databases. http://www.blinex.com/~sam/CF_SQL_TYPES.cfm This is starting to get off the container topic, but Beth, are you using the Oracle JDBC driver provided by Macromedia? If so do you know what version? --Nathan >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf >Of Beth Bowden >Sent: Thursday, October 14, 2004 8:19 AM >To: FarCry Developers >Subject: [farcry-dev] Re: Container Problem (fixed) > >I'm running CFMX 6,1,0,83762 Enterprise and Developer. > >I can only speak to Oracle. I forget the numbers but my >longer pages were truncated using CF_SQL_LONGVARCHAR. W/ the >CF_SQL_CLOB, I've stored up to 1,413,000 characters w/o problems. > >On Thu, 14 Oct 2004 22:01:02 +1000, Geoff Bowers ><[EMAIL PROTECTED]> wrote: >> Beth Bowden wrote: >> > I've found that using <cfqueryparam >cfsqltype="CF_SQL_CLOB"> allows >> > much larger strings than does <cfsqltype="CF_SQL_LONGVARCHAR"> for >> > Oracle. However, I believe you need to have updated to the latest >> > version of ColdFusion. >> >> Can you tell us specifically what version of CFMX? (I presume you're >> referring to the driver library?) >> >> > If line 104 in \fourq\_fourq\setData.cfm is changed to use >> > 'CF_SQL_CLOB', it would be very helpful. >> >> Are you saying this would be helpful in general or helpful >> specifically for Oracle implementations?? >> >> >> >> -- geoff >> http://www.daemon.com.au/ >> >> --- >> You are currently subscribed to farcry-dev as: >[EMAIL PROTECTED] To >> unsubscribe send a blank email to >> [EMAIL PROTECTED] >> Aussie Macromedia Developers: http://lists.daemon.com.au/ >> > >--- >You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >[EMAIL PROTECTED] >Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
