Len would tell me the length not the size of the client variables. I don't see how Unicode would be the problem if the problem only occurs when the client variables reach a certain size. The SQL Server field size is not an issue. This works with the same DB with CF4.5.
At 10:46 PM 08/08/02 +0200, you wrote: >Brook Davies wrote: > > > > I'm not sure if this is the correct way to calculate the size of the client > > var data, but I used <cfdump> to output it and then cut and paste it into a > > notepad and the doc weighed 17k. In general the application's client var > > string will almost never be this big, I was just testing. > >Wouldn't Len() work directly in the database? And might the problem be >caused by Unicode using double byte characters? > > > > But in CF4.5 I thought the size limit was around 32k. It was definetly > > bigger than 17k! > > Has any one seen something similar? Can some one test this by doing a > > <cffile action="read" file="my17kfile.txt" variable="client.myclientvar"> > > or something similar while client variables are enabled for DB storage. > >The database I use for client variables allows up to 1 GB per field. So >I suppose you could just change the datatype to something bigger (I >presume MS SQL Server has something bigger as 32 KB). > >Jochem > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
