Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to MySQL Request SQLWays

MySQL Data Types - LONGBLOB

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

MySQL - LONGBLOB
Syntax LONGBLOB
Data Variable-length binary data
Range 4G (232 – 1) 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 LONGBLOB - Equivalents in Other Databases

Database Data Type and Conversion
Oracle BLOB, 4G
SQL Server VARBINARY(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified
PostgreSQL BYTEA, 1G
Sybase ASE IMAGE, 2G
Informix BYTE, 2G, BLOB, 2T

Related Data Types in MySQL

Data Types
Fixed-length binary data BINARY(n)
Variable-length binary data VARBINARY(n) TINYBLOB BLOB MEDIUMBLOB

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Migration to MySQL Request SQLWays

sqlways/mysql/data-types/longblob.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement