What is a Blob Data type

I was just looking through the Alteryx data type docs and couldn't find a section on Blob's Data Types | Alteryx Help. From definitions online its a 'Binary large object'. What are the advantages/limitations of using this data type?

Thanks in advance for any information on this.

Input

Tips and Tricks

Help

Accepted answers

rohit782192

BLOB is Binary Large Objects. It contains Image which come from your application and get save in Database.

For Eg : If you upload a photograph in your school or college form it will get save in your Database as Blob format.

SPetrie

I do not believe it does any compression. I am under the impression that is is a direct translation of the source into binary for storage in a database.

You dont have to use just pictures either. Blobs can be audio, video, or other forms of media. You can use it for other file types as well depending on your use case. I use blob input and output to move excel templates for use in gallery workflows where I need pre-formatted excel files.

All comments

rohit782192

BLOB is Binary Large Objects. It contains Image which come from your application and get save in Database.

For Eg : If you upload a photograph in your school or college form it will get save in your Database as Blob format.

rohit782192

I have used in Database comparison from Oracle 11g to Oracle 12c

IraWatt

Thanks @rohit782192, do you know if it compress the image in any way?

SPetrie

I do not believe it does any compression. I am under the impression that is is a direct translation of the source into binary for storage in a database.

IraWatt

Thanks @SPetrie and @rohit782192 !

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280