User-defined data types, which are aliases for system-supplied data types, can also be defined. For more information about user-defined data types, see sp_addtype and Creating User-defined Data Types.
When two expressions that have different data types, collations, precision, scale, or length are combined by an operator:
- The data type of the resulting value is determined by applying the rules of data type precedence to the data types of the input expressions. For more information, see Data Type Precedence.
- If the result data type is char, varchar, text, nchar, nvarchar, or ntext, the collation of the result value is determined by the rules of collation precedence. For more information, see Collation Precedence.
- The precision, scale, and length of the result depend on the precision, scale, and length of the input expressions. For more information, see Precision, Scale, and Length.
SQL Server provides data type synonyms for SQL-92 compatibility. For more information, see Data Type Synonyms.
SQL Server 2000
| Data Category | SQL Server 2000 | MapInfo Pro |
| Integers | bigint Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). |
LargeInt |
int Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). |
Integer | |
smallint Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767). |
Small Integer | |
|
tinyint Integer data from 0 through 255. |
Small Integer | |
| Bit |
bit Integer with a 1 or 0 value. |
Logical |
| Decimal and Numeric |
decimal Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1. |
Decimal |
|
numeric Functionally equivalent to a decimal |
Decimal | |
| money and smallmoney |
money Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. |
Float |
|
smallmoney Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. |
Decimal | |
| Approximate Numerics |
float Floating precision number data from -1.79E + 308 through 1.79E + 308. |
Float |
|
real Floating precision number data from -3.40E + 38 through 3.40E + 38. |
Float | |
| datetime and smalldatetime |
datetime Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds. |
Date |
|
smalldatetime Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. |
Date | |
| Character Strings |
char Fixed-length non-Unicode character data with a maximum length of 8,000 characters. |
Char |
|
varchar Variable-length non-Unicode data with a maximum of 8,000 characters. |
Char | |
|
text Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. |
Char(256) Read Only |
|
| Unicode Character Strings |
nchar Fixed-length Unicode data with a maximum length of 4,000 characters. |
Not supported |
|
nvarchar Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names. |
Char Read only |
|
|
ntext Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. |
Not supported | |
| Binary Strings |
binary Fixed-length binary data with a maximum length of 8,000 bytes. |
Char Read only |
|
varbinary Variable-length binary data with a maximum length of 8,000 bytes. |
Char Read only |
|
|
image Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes. |
Char(256) Read Only |
|
| Other Data Types |
sql variant A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant. |
Via SpatialWare support for St_Spatial |
|
timestamp A database-wide unique number that gets updated every time a row gets updated. |
Char Read only |
|
|
uniqueidentifier A globally unique identifier (GUID). |
Not supported |
SQL Server 2005
For SQL Server 2005, refer to the SQL Server 2000 server data type equivalence table with the following addition:
| Data Category | SQL Server 2005 | MapInfo Pro |
|---|---|---|
| XML |
XML The SQL Server 2005 XML data type implements the ISO SQL-2003 standard XML data type. |
Not Supported |
SQL Server 2008
For SQL Server 2008, refer to the SQL Server 2000 and SQL Server 2005 server data type equivalence tables with the following additions:
| Data Category | SQL Server 2008 | MapInfo Pro |
| Spatial |
geometry Supports planar, or Euclidean (flat-earth), data, and conforms to the Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0. |
MapInfo Map Object |
|
geography Stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates. |
MapInfo Map Object | |
| Date | Date | Date |
|
TIME Similar to the Date datatype. Used to store only time information. |
Time | |
DATETIMEOFFSET Saving the date and time in a column does not indicate time zone information. |
Character Read Only | |
DateTime2 A date/time datatype with larger fractional seconds and year range than the existing DATETIME datatype. |
DateTime |