SQLWays Product Page - Migration to MySQL
Free Evaluation
Versions: MySQL 5.x, 4.x and 3.23
| MySQL - TINYBLOB | |
|---|---|
| Syntax | TINYBLOB |
| Data | Variable-length binary data |
| Range | 255 bytes |
| Trailing Zeros | Not removed when the value is stored and retrieved. Trailing zeros are significant in comparisons |
| Error Handling | Exceeding data truncated and a warning is generated if strict SQL mode is not enabled, otherwise an error is raised |
| Storage Size | Actual entry length |
| Standards | MySQL Extension |
MySQL TINYBLOB - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | RAW(n), 1 ⇐ n ⇐ 2000 |
| SQL Server | VARBINARY(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified |
| PostgreSQL | BYTEA, 2G |
| Sybase ASE | VARBINARY(n), 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K) |
| Informix | BYTE, 2G, BLOB, 2T |
Related Data Types in MySQL
| Data Types | |||
|---|---|---|---|
| Fixed-length binary data | BINARY(n) | ||
| Variable-length binary data | VARBINARY(n) | BLOB | MEDIUMBLOB |
| Binary large objects | LONGBLOB | ||
All Data Types
| Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird |
Discussion