MicroStrategy support for binary data types

MicroStrategy maps binary data types from databases to either the Binary or Varbin MicroStrategy data types. For example, some databases are listed below with their various binary data types and their MicroStrategy mapping:

Database	Mapped to Binary Data Type	Mapped to Varbin Data Type
Oracle	Not Applicable	Raw
Teradata	Byte	Varbyte
SQL Server	Binary	Varbinary
Sybase IQ	Binary	Varbinary
Sybase ASE	Binary	Varbinary
MySQL	Binary	Varbinary
PostgreSQL	Bit	Bit Varying

To determine how and when to use binary data types in MicroStrategy, the following MicroStrategy features are supported for binary data types:

•

MicroStrategy supports the following features for attributes that have an ID form mapped to a binary data type:

▫

Element list qualifications.

▫

Drilling.

▫

Element browsing.

▫

Page-by.

▫

Sorting.

▫

Exporting, which exports the binary data as a string of characters.

•

MicroStrategy supports the following features for any attributes that have non-ID attribute forms that are mapped to a binary data type:

▫

Inclusion in data marts (SQL Server only)

▫

Attribute form qualifications, excluding qualifications that use operators to compare characters such as Like or Contains.