Both FCAS and databases require that all data contained in their data structures have explicit data types. If your application will be connecting to a database, you must be sure to use data types that are compatible with the corresponding database data types. These are the FCAS counterparts for common ODBC database data types: FCAS ODBC database Integer integer, int, smallint, tinyint, boolean, bit, yes/no Long integer, int, smallint, tinyint, boolean, bit, yes/no Single float, double, single, double precision, decimal, numeric Double float, double, single, double precision, decimal, numeric Currency monetary, money, currency, smallmoney String char, character, varchar, variable character, text, memo Date date, time, date/time, datetime, smalldatetime