http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-26T06:05:14 en-us http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/sharedVars4.htm#19004 The differences in field length are usually from historical reasons. CF4.5 picked a certain length, and during the subsequent upgrades, the table metadata is kept intact. For new installs, the tables are created fresh. Therefore the length maybe different depends on the upgrade path.<br><br>If you run into problems, the best course of action is usually to create new client storage tables, and migrate over the old data. jrunrandy 1 0 2004-07-27T06:23:25 http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/sharedVars4.htm#18906 We have a lot of web clients and thier settings of CDATA and CGLOBAL are slightly different. ex) A CDATA of a client has cfid of 20 char while another client has cfid of 100 char in our MS-SQL server. I want to know why our CF5 Server created the client variable storages so differently for each client. This issue produces "Truncation error" on the database server from time to time and I believe it is the root of the notorious Location Code 26 error we are receiving a lot recently. Please give us some explanation. Also I have seen cfids and cftoekens longer than 64 bytes. badugi77 0 0 2004-07-22T10:36:07 http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/sharedVars4.htm#1043 When creating the CDATA and CGLOBAL client table in an Oracle database, it may help to select a datatype of CLOB for the "data" columns. CLOB would be the equivalent of MEMO, LONGTEXT, LONG VARCHAR. The datatype of LONG has been deprecated in Oracle. adrapley 0 0 2003-05-12T13:08:00