SQL Server VARBINARY Type Features Variable-length binary data type (replaces legacy IMAGE type in SQL Server 2005+) VARBINARY(n): Stores up to n bytes (n = 1 to 8000) for small/medium images VARBINARY(MAX): Stores up to 2GB per value (ideal for high-resolution images) Integrated with FILESTREAM ... Read more
Author Archives: Shiji Pan
CLOB
CLOB stands for Character Large Object. It is a data type used in various database management systems to store large amounts of character data, such as long texts, articles, XML documents, and other forms of unstructured text. DB2 CLOB In DB2, CLOB (Character Large Object) is a data type used to ... Read more
Store Excel spreadsheets in PostgreSQL BYTEA
Excel spreadsheets can be stored as PostgreSQL BYTEA data. DBBlobEditor can help you to store Excel spreadsheets as PostgreSQL BYTEA data: Batch import excel files into PostgreSQL BYTEA Batch export PostgreSQL BYTEA to EXCEL files ... Read more
Store Word documents in PostgreSQL BYTEA
Word documents can be stored as PostgreSQL BYTEA data. DBBlobEditor can help you to store Word documents as PostgreSQL BYTEA data: Batch import Word files into PostgreSQL BYTEA Batch export PostgreSQL BYTEA to Word files ... Read more
Store PDF files in PostgreSQL BYTEA
PostgreSQL BYTEA Overview PostgreSQL does not have a native BLOB type; BYTEA (binary string) is the official recommended type for storing binary data like PDFs, supporting up to 1 GB of data. Step-by-Step Implementation Method 1: Manual SQL Statements (Primary Method) 1. Create Table CREATE TABLE ... Read more
Store video files in PostgreSQL BYTEA
Video files can be stored as PostgreSQL BYTEA data. 1. Core Compatible Type & PostgreSQL BYTEA Fundamentals PostgreSQL does not have a native BLOB type; it uses the BYTEA (Binary Data) data type as the primary solution for storing large binary files like videos. BYTEA supports unlimited ... Read more
Store audio files in PostgreSQL BYTEA
Audio (MP3, WAV, Ogg, WMA, M4A, AAC, etc.) files can be stored as PostgreSQL BYTEA data. 1. Key Overview PostgreSQL uses BYTEA (Binary Data) type (instead of native BLOB) for storing mp3/wav/ogg audio files (up to 1 GB max for BYTEA). Storing audio as BYTEA integrates audio data with business ... Read more
Store images in PostgreSQL BYTEA
PostgreSQL BYTEA Type Features BYTEA (byte array) is PostgreSQL’s native binary data type (replaces legacy BLOB support) Supports up to 1GB of binary data (limited by PostgreSQL’s page size and TOAST compression) Two storage formats: Hex (default in PostgreSQL 9.0+) and Escape ... Read more
SQLite BLOB
In SQLite, the BLOB (Binary Large Object) data type is used to store binary data such as images, audio files, or any other non – text data. Here’s a comprehensive guide on working with BLOB in SQLite: 1. Creating a Table with a BLOB Column You can create a table with a BLOB column to ... Read more
MySQL BLOB
In MySQL, the BLOB (Binary Large Object) data types are used to store large amounts of binary data, such as images, audio, and video files. MySQL provides four different BLOB data types, each with different maximum storage capacities: TINYBLOB: Can store up to 255 bytes of binary data. BLOB: Can ... Read more