65k is the limit of the ODBC set as a default to interface with a DB ..(MS SQL or Oracle)
hence it will only take 65K chars and dump it into the DB the rest is ignored. i assume they use 31999 cause the update/insert wont take too long to run... hence not a big HIT on the server and DB... (i could be wrong) also if u wanna increase the 65K limit... from CF 4.5+... in the CF admin you can change it when Adding/Editing a ODBC Connection.. they is a field called "Long Text Buffer Size" cheers Joel -----Original Message----- From: Richard Ragan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 February 2002 11:39 To: Spectra-Talk Subject: Re: LONG_CHAR_MAX_LENGTH My guess would be that this is 32768 - however many chars it takes to "frame" a WDDX serialized object. Of course, why 32768 vs. 65536, beats me. This might derive from using SQL Anywhere since it might have some funky limits. But then again, maybe it's someone thinking decimal and counting base zero so 31999 amount to 32K (decimal) bytes and would be a more arbitrary restriction. Rich ----- Original Message ----- From: "Todd M" <[EMAIL PROTECTED]> To: "Spectra-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 4:29 PM Subject: LONG_CHAR_MAX_LENGTH > I'm curious as to why Spectra chooses to set the textsize length to 31999? > > Why not 64512 or some other number? > > <cfset request.cfa.LONG_CHAR_MAX_LENGTH = "31999"> > -------------------------------------------------------------------------- ---- > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
