Question : I need to match a binary column with its beginning. For text columns it’s easy: LIKE ‘image/%’. This […]
Tag: blob
How to copy bytea from Postgres to Oracle
Question : I have a db on Postgres 9.1. The db collected some binary data that are stored in bytea […]
Replacing a large object in PostgreSQL
Question : What should one do when one wishes to replace a large object with a new large object. An […]
Why does my table keep getting corrupted after removing large amounts of data?
Question : I have a database that is about 400 gigs. The majority of the space is consumed by images […]
Compress files and directories into zip file and put it into blob field
Question : What is the best way to do the following using SQL Server? Compress all the files, folders and […]
Should binary files be stored in the database?
Question : What is the best place for storing binary files that are related to data in your database? Should […]
oid vs bytea in postgres
Question : I have a table called tblA and its having two columns id_ (numeric 50,0), obj_ oid For example, […]
Saving LZW encoded data into a mySQL database
Question : I send LZW compressed data from the client side with JavaScript to the server. The problem is that […]
BLOBs storage in a dedicated table
Question : I have a database that has several BLOB columns scattered across multiple tables. Since I am a developer […]
How to copy blob (binary data) from one DB to DB using a script?
Question : We are trying to copy a blob (binary data) from one Database to another Database using a simple […]