The Advanced SQL Engine has 3 Byte data types:
| SQL Engine Data Type | Description |
|---|---|
| Byte (n) | Represents a fixed-length binary object. "n" specifies the number of Bytes. |
| Blob (n) | Represents a variable length Binary Large Object (BLOB). "n" specifies the maximum number of Bytes. |
| VarByte (n) | Represents a variable length binary object. "n" specifies the maximum number of bytes. |
The "SQL Data Type and Literals" manual describes each type in detail. This sections shows how the SQL Engine Byte data types map to the .NET Framework type system.
The Base Class Library (BCL) has 1 Byte data types:
The .NET Data Provider for Teradata has one Byte Provider Specific Type and it also converts the SQL Byte data type to the BCL types.
| SQL Data Type | BCL Type | Provider Specific Type |
|---|---|---|
| Byte | System.Byte[] | NA |
| VarByte | System.Byte[] | NA |
| BLOB | System.Byte[] | TdBlob |