Data type mapping
- Last UpdatedFeb 12, 2024
- 1 minute read
The following table lists the conversion of AVEVA BI Gateway model field types into .NET data types and from .NET data types into SQL data types in the datastore.
|
Field type in BI Gateway model |
.NET data type |
SQL data type |
|---|---|---|
|
Boolean |
System.Boolean |
[bit] |
|
Int16 |
System.Int16 |
[smallint] |
|
Int32 |
System.Int32 |
[int] |
|
Decimal |
System.Decimal |
[decimal](18, 0) |
|
Int64 |
System.Int64 |
[bigint] |
|
Float (not supported) |
[real] |
|
|
Guid |
System.Guid |
[uniqueidentifier] |
|
Double |
System.Double |
[float] |
|
String |
System.String |
[nvarchar](4000) |
|
DateTime |
System.DateTime |
[datetime2] (7) |
|
Byte |
System.Byte |
[tinyint] |
|
System.Byte[] |
[varbinary](max) |
|
|
Other |
SQLVariant |