Enum DataType
List of data types, supported by linq2db. Provider-level support depends on database capabilities and current implementation support level and could vary for different providers.
Namespace: LinqToDB
Assembly: linq2db.dll
Syntax
public enum DataType : intFields
| Name | Description |
|---|---|
| BFile | Oracle BFILE data type. |
| Binary | A fixed-length stream of binary data ranging between 1 and 8,000 bytes. |
| BinaryJson | Binary type utilized postgres provider (jsonb). |
| BitArray | Array of bits. |
| Blob | Binary large object. |
| Boolean | A simple type representing Boolean values of true or false. |
| Byte | An 8-bit unsigned integer ranging in value from 0 to 255. |
| Char | A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| Cursor | Result set (for example OracleDbType.RefCursor). |
| Date | A type representing a date value. |
| DateTime | Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
| DateTime2 | Date and time data. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. |
| DateTimeOffset | Date and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00. |
| DecFloat | Type representing number with fixed precision and floating scale. |
| Decimal | A simple type representing values with fixed precision and scale numbers. When maximum precision is used, valid values are from -10^38+1 through 10^38-1. |
| Dictionary | Dictionary type for key-value pairs. |
| Double | A floating point number within the range of -1.79E +308 through 1.79E +308. |
| Enum | PostgreSQL Enum type. |
| Guid | A globally unique identifier (or GUID). |
| Image | A variable-length stream of binary data ranging from 0 to 2 31 -1 (or 2,147,483,647) bytes. |
| Int128 | An integral type representing signed 128-bit integers with values between -170141183460469231731687303715884105728 and 170141183460469231731687303715884105727. |
| Int16 | An integral type representing signed 16-bit integers with values between -32768 and 32767. |
| Int32 | An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. |
| Int64 | An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807. |
| Interval | PostgreSQL interval type. |
| Json | Json type utilized in postgres provider. |
| Long | Oracle data type for storing character data of variable length up to 2 Gigabytes in length (bigger version of the VARCHAR2 datatype). |
| LongRaw | Oracle data type for storing binary data of variable length up to 2 Gigabytes in length. |
| Money | A currency value ranging from -2 63 (or -9,223,372,036,854,775,808) to 2 63 -1 (or +9,223,372,036,854,775,807) with an accuracy to a ten-thousandth of a currency unit. |
| NChar | A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters. |
| NText | A variable-length stream of Unicode data with a maximum length of 2 30 - 1 (or 1,073,741,823) characters. |
| NVarChar | A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters. Oracle: We need NVarChar2 in order to insert UTF8 string values. The default Odp VarChar2 dbtype doesnt work with UTF8 values. Note : Microsoft oracle client uses NVarChar value by default. Same as VARCHAR2 except that the column stores values in the National CS , ie you can store values in Bangla if your National CS is BN8BSCII .If the National CS is of fixed width CS (all characters are represented by a fixed byte ,say 2 bytes for JA16EUCFIXED) , then NVARCHAR2(30) stores 30 Characters. Varchar2 works with 8 bit characters where as Nvarchar2 works ith 16 bit characters. If you have to store data other than english prefer Nvarchar2 or viceversa. NCHAR and NVARCHAR2 are Unicode datatypes that store Unicode character data. The character set of NCHAR and NVARCHAR2 datatypes can only be either AL16UTF16 or UTF8 and is specified at database creation time as the national character set. AL16UTF16 and UTF8 are both Unicode encoding. The NCHAR datatype stores fixed-length character strings that correspond to the national character set.The NVARCHAR2 datatype stores variable length character strings. When you create a table with an NCHAR or NVARCHAR2 column, the maximum size specified is always in character length semantics. Character length semantics is the default and only length semantics for NCHAR or NVARCHAR2. For example, if national character set is UTF8, then the following statement defines the maximum byte length of 90 bytes: CREATE TABLE tab1 (col1 NCHAR(30)); This statement creates a column with maximum character length of 30. The maximum byte length is the multiple of the maximum character length and the maximum number of bytes in each character. The maximum length of an NVARCHAR2 column is 4000 bytes. It can hold up to 4000 characters. The actual data is subject to the maximum byte limit of 4000. The two size constraints must be satisfied simultaneously at run time. |
| SByte | An integral type representing signed 8-bit integers with values between -128 and 127. |
| Single | A floating point number within the range of -3.40E +38 through 3.40E +38. |
| SmallDateTime | Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute. |
| SmallMoney | A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit. |
| Structured | SQL Server 2008+ table-valued parameter type (TVP). |
| Text | A variable-length stream of non-Unicode data with a maximum length of 2 31 -1 (or 2,147,483,647) characters. |
| Time | A type representing a time value. |
| Timestamp | Array of type Byte. Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes. |
| TimeTZ | Type representing a time value with timezone or offset. |
| Udt | A SQL Server 2005 user-defined type (UDT). |
| UInt16 | An integral type representing unsigned 16-bit integers with values between 0 and 65535. |
| UInt32 | An integral type representing unsigned 32-bit integers with values between 0 and 4294967295. |
| UInt64 | An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615. |
| Undefined | Undefined data type. |
| VarBinary | A variable-length stream of binary data ranging between 1 and 8,000 bytes. Implicit conversion fails if the byte array is greater than 8,000 bytes. |
| VarChar | A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. Use VarChar when the database column is varchar(max). |
| Variant | A general type representing any reference or value type not explicitly represented by another DataType value. |
| VarNumeric | A variable-length numeric value. |
| Xml | An XML value. Obtain the XML as a string using the GetValue method or Value property, or as an XmlReader by calling the CreateReader method. |