Data Type

Select the data type to assign to the IDO property. If the property has a data type assigned already, this field displays the data type.

The default data type of an IDO property is usually the SQL Server data type on which a SQL Server user-defined data type is based. The user-defined data type is referred to as the Column Type attribute of the IDO property.

This table lists and describes the various data type designations used in Mongoose-based applications:

IDO property data type Mongoose data type SQL Server base data type Descriptions of SQL Server base data types
Binary BINARY binary, varbinary, image binary: Fixed-length binary data from 1 through 8,000 bytes

varbinary: Variable-length binary data from 1 through 8,000 bytes

image: Variable-length binary data from 0 through 231-1 (2,147,483,647) bytes

Byte I1 tinyint Integers 0 through 255
Currency CURRENCY money Fixed precision and scale numeric data from −10^38 +1 through 10^38 − 1
Date DATE datetime Date and time
Decimal DECIMAL decimal, numeric Fixed precision and scale numeric data from −10^38 +1 through 10^38 − 1
EncryptedString ENCRYPTEDCHAR nvarchar nvarchar: Variable-length Unicode data with a maximum length of 4,000 characters

The EncryptedString length should be 1.5 times the longest string stored in the column, with a minimum length of 24 characters.

Float R4, R8 float Floating point number data from −1.79E + 308 through 1.79E + 308
GUID CHAR uniqueidentifier A value is initialized by the SQL NEWID function or by converting from a string constant

A string constant is in the form xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, where each x is a hexadecimal digit in the range 0-9 or a-f.

Long Integer I4 int Integers −2^31 (−2,147,483,648) through 2^31 − 1 (2,147,483,647)
NumSortedString NUMSORTCHAR nvarchar, nchar nvarchar: Variable-length Unicode data with a maximum length of 4,000 characters

nchar: Fixed-length Unicode data with a maximum length of 4,000 characters

Short Integer I2 smallint Integers −2^15 (−32,768) through 2^15 − 1 (32,767)
String CHAR nvarchar, nchar nvarchar: Variable-length Unicode data with a maximum length of 4,000 characters

nchar: Fixed-length Unicode data with a maximum length of 4,000 characters

Note: NumSortedString in IDOs and NUMSORTCHAR in the client are special cases of string data that are padded for the purpose of numeric sorting.