MicroStrategy data types

When the data warehouse catalog is read from the Warehouse Catalog, all columns in the database are automatically mapped to one of the following MicroStrategy data types.

Data Type	Description
Big Decimal	High-precision fixed point numbers.
Binary	Fixed-length bit strings. Similar to ANSI BIT.
Char	Fixed-length character strings. Similar to ANSI CHAR.
Date	Calendar dates. Similar to ANSI DATE.
Decimal	Fixed point numbers up to 15 digits of precision. Similar to ANSI DECIMAL.
Double	8-byte floating point numbers. Similar to ANSI DOUBLE PRECISION.
Float	4-byte floating point numbers. Similar to ANSI FLOAT.
Integer	Signed integer values. Similar to ANSI INTEGER.
LongVarBin	Large strings of bits. Similar to ANSI BLOB.
LongVarChar	Large strings of characters. Similar to ANSI CLOB.
NChar	Fixed-length character strings used to support various character sets.
Numeric	Fixed point numbers up to 15 digits of precision. Similar to ANSI NUMERIC.
NVarChar	Variable-length character strings used to support various character sets.
Real	4-byte floating point numbers. Similar to ANSI REAL.
Time	Time of day. Similar to ANSI TIME.
Timestamp	Combinations of calendar date and time of day. Similar to ANSI TIMESTAMP.
Unsigned	Unsigned integer values.
VarBin	Variable-length bit strings. Similar to ANSI BIT VARYING.
VarChar	Variable-length character strings. Similar to ANSI VARCHAR.

If the Warehouse Catalog displays a column with data type as Unknown, it implies that the data type in the database has not mapped to one of the MicroStrategy data types.