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.