16
CONFIGURING AND ADMINISTERING COLDFUSION 10
Using the ColdFusion Administrator
L
ast
u
p
dated
7/9/2
01
2
Migrating client variable data
To migrate your client variable data to another data source, determine the structure of the database tables that store
this information. Client variables stored externally use two simple database tables, as shown in the following tables:
Creating client variable tables
Use the following sample ColdFusion page as a model for creating client variable database tables in your own database.
However, keep in mind that not all databases support the same column data type names. For the proper data type, see
your database documentation.
Note:
The ColdFusion Administrator can create client variable tables for data sources that use one of the bundled JDBC
drivers. For more information, see the Online Help.
CDATA Table
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 Table
Column
Data type
cfid
CHAR(64), TEXT, VARCHAR, or equivalent
data
MEMO, LONGTEXT, LONG VARCHAR, or equivalent
lvisit
TIMESTAMP, DATETIME, DATE, or equivalent