Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Data Types - VARBINARY

Versions: MySQL 5.x, 4.x and 3.23

MySQL - VARBINARY
Syntax VARBINARY(n)
Data Variable-length binary data
Parameters n is the maximum number of bytes, optional
Range 1 ⇐ n ⇐ 65535 (maximum row size shared among all columns)
Default n is mandatory
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

If strict SQL mode is not enabled, a VARBINARY column with a length greater than 65535 is converted to BLOB, otherwise an error is generated
Storage Size Actual entry length
Standards MySQL Extension

MySQL VARBINARY - Equivalents in Other Databases

Database Data Type and Conversion
Oracle RAW(n), 0 ⇐ n ⇐ 2000, BLOB, 4G
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 TINYBLOB BLOB MEDIUMBLOB
Binary large objects LONGBLOB

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.