Data Types » MicroStrategy data types

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.