Data Type
Select the data type to assign to the IDO prooperty. 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 | : Variable-length binary data from 1 through 8,000 bytes : Variable-length binary data from 0 through 231-1 (2,147,483,647) bytes |
: Fixed-length binary data from 1
through 8,000 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 | The EncryptedString length should be 1.5 times the longest string stored in the column, with a minimum length of 24 characters. |
:
Variable-length Unicode data with a maximum length of 4,000 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 | : Fixed-length Unicode data with a maximum length of 4,000 characters |
: Variable-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 | : Fixed-length Unicode data with a maximum length of 4,000 characters |
: Variable-length Unicode data with a
maximum length of 4,000 characters
NumSortedString in IDOs and NUMSORTCHAR in the client are special cases of string data that are padded for the purpose of numeric sorting.