Question : We have replication set up on a VARBINARY(MAX) column that stores image data (yes, yes, I know – […]
LIKE or match by beginning for binary strings in PostgreSQL
Question : I need to match a binary column with its beginning. For text columns it’s easy: LIKE ‘image/%’. This […]
GZip existing varbinary(max) column in Sql Server 2008+
Question : I have an existing legacy table that is ~180GB in size due to a client application storing PDF […]
How can I decrypt data on a replicated MSSQL database?
Question : I have a database which uses a symmetric key to encrypt a credit card field. There is a […]
How do I migrate varbinary data to Netezza?
Question : I got a warning message while migrating DDL from SQL Server to Netezza: Warning: [dbo].[spec_binarymessage].[blobdata] data type [varbinary] […]
sql server replication – how to get combination of values from a binary(8) field?
Question : I am using the table sysschemaarticles to collect information in my transactional replication. It is used for a […]
Comparing binary 0x and 0x00 turns out to be equal on SQL Server
Question : It seems that SQL Server considers 0x and 0x00 equal values: SELECT CASE WHEN 0x = 0x00 THEN […]
Update a binary field
Question : How to update a binary field from 0x54 to 0x46 (T to F)? Update dbo.table1 set field = […]
BLOB or VARBINARY to store simple Strings that are converted into byte[ ]?
Question : I’ve read that In MySQL, BLOBs are often used to store image files, file path pointers, video & […]
Store Mesh in database
Question : I hope this is the correct forum but will ask anyway: I have lots of Mesh data I […]