Server Settings


Migrate client variable data

You should understand the structure of the database tables that store client information if you have to migrate client variable data to another data source.

 

Client variables that are stored externally use the database tables with the structure shown in the following tables:

 

CDATA

Column

Data type

cfid

CHAR(64), TEXT, VARCHAR, or equivalent

app

CHAR(64), TEXT, VARCHAR, or equivalent

data

MEMO, LONGTEXT, LONG VARCHAR , or equivalent

 

CGLOBAL

Column

Data type

cfid

CHAR(64), TEXT, VARCHAR, or equivalent

data

MEMO, LONGTEXT, LONG VARCHAR, or equivalent

lvisit

TIMESTAMP, DATETIME, DATE, or equivalent

 

Different DBMSs require different data types. Ensure that you choose the data type that applies to your DBMS. For information about creating client variable tables, see ColdFusion Developer's Guide.

Related topics