What is a BLOB in SQL or MySQL?
Solved
Myriam
-
oussama61 -
oussama61 -
I would like to know what a BLOB is exactly; I know it's a Binary Large Object, but I can't see what it corresponds to concretely. I really know what an int corresponds to, but not a BLOB.
Thank you in advance...
Thank you in advance...
4 answers
It's a type of field that allows you to store binary data (any kind of files: image, text, EXE file, ZIP... anything you want).
It's often used to store images.
The term BLOB can vary from one server to another (for example, in Microsoft SQL Server, BLOB fields are of type BINARY or IMAGE).
Advantage: it allows you to store anything.
Disadvantage: retrieving the content of a blob field usually takes time (SQL servers are not designed to store large amounts of binary data).
Another disadvantage: you cannot use blob fields in WHERE clauses.
It's often used to store images.
The term BLOB can vary from one server to another (for example, in Microsoft SQL Server, BLOB fields are of type BINARY or IMAGE).
Advantage: it allows you to store anything.
Disadvantage: retrieving the content of a blob field usually takes time (SQL servers are not designed to store large amounts of binary data).
Another disadvantage: you cannot use blob fields in WHERE clauses.
Would you happen to know a document or a book that would explain this kind of stuff...?
The one I have is a bit limited (MySQL online from Micro application), I was told afterwards that it wasn't great.