Mapping columns with BLOB format type in Microstrategy

Mapping columns with BLOB format type in Microstrategy

Columns in the data source that use BLOB format types can be mapped to attribute forms and facts in MicroStrategy as the LongVarBin data type.

According to Microstrategy the data types such as Picture, BLOB, Text depending on data can be assigned as LongVarBin data type in the attribute definition.

LongVarBin

Picture, BLOB, Text depending on data

This data type is treated as a long string of binary data. 

This representation in MicroStrategy has the following effects on including data from a BLOB format type on a MicroStrategy report or document:

•

Since the BLOB format type is represented as a LongVarBin, the data is displayed in either binary or hexadecimal representation. The data is not converted into any other format such as an image or PDF format. Therefore, columns in a data source that use BLOB format types to represent images, PDFs, or other non-binary or hexadecimal data should not be included in MicroStrategy.

•

MicroStrategy supports BLOB format types that include data records of up to 32 Kilobytes. If a BLOB, that contains more than 32 Kilobytes, is included in a report, this can cause an error with a message such as String data, right truncated. Below Information will be useful for further knowledge: Different format types are compatible with different data types given the specific data in your column. Therefore, some of the data type-format type combinations below may not work with your specific data. Data Type Compatible Format Types Big Decimal Big Decimal Binary Number, Text, Picture Char Text, URL, E-mail, HTML Tag Date Date, Datetime Decimal Number Double Number Float Number Integer Number LongVarBin Picture, BLOB, Text depending on data LongVarChar Picture, Text Numeric Number Real Number Time Time, Datetime Timestamp Datetime, Date or Time depending on data Unsigned Number VarBin Picture, Text VarChar Text, URL, E-mail, HTML Tag, Picture