Blob - MSSQL (Magic xpa 2.x)
The table below lists Magic xpa’s Blob attribute and the valid data types in MSSQL. Each entry in the table has a default data type that can be forced by specifying that type in the Type property on the SQL section in the Column Properties sheet.
|
Magic xpa Storage Type
|
Magic xpa Storage Size
|
MSSQL Data Type
|
|
BLOB Binary
|
28
|
IMAGE
|
|
BLOB Ansi
|
28
|
TEXT*
|
|
BLOB Unicode
|
28
|
NTEXT
|
* The recommended method of inputting data into a TEXT field is either by using the Update operation or the File2Blb function. When using this data type in a Direct SQL statement, the maximum blob size will be 64K. To change that size (either increasing or decreasing it) you can use the SQLBLOB = size keyword in the database properties.
Note: When you retrieve data from this field, Magic xpa adds an extra byte to the end of the BLOB. When you use the Blb2File function to save the BLOB to a file, the file size will be one byte larger than the original size.
