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 | : Fixed-length binary data from 1 through 8,000 bytes
: Variable-length binary data from 1 through 8,000 bytes : 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 | : 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 | : Variable-length Unicode data with a maximum length of 4,000 characters
: 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 | : Variable-length Unicode data with a maximum length of 4,000 characters
: Fixed-length Unicode data with a maximum length of 4,000 characters |