The Teradata Database has 3 Byte data types:
| Teradata Database 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 Teradata Database "SQL Data Type and Literals" manual describes each type in detail. This sections shows how the Teradata Database 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 Teradata Database Byte data type to the BCL types.
| Teradata Database Type | BCL Type | Provider Specific Type |
|---|---|---|
| Byte | System.Byte[] | NA |
| VarByte | System.Byte[] | NA |
| BLOB | System.Byte[] | TdBlob |