Data Types » MicroStrategy support for binary data types

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.