BLOB / CLOB data type
- Thread starter lord_icon
- Start date
manage pictures and xml files, respectively
mpowell_esq
Member
Greetings,
So a BLOB and CLOB datatype, store image XML details. To do what (objective). Isnt this possible with CHAR datatypes?
So a BLOB and CLOB datatype, store image XML details. To do what (objective). Isnt this possible with CHAR datatypes?
Hello Martin,
I meant it as an example, i.e. store binary data e.g. images in BLOBs, and text e.g. XML in CLOBs.
For example, an archive app for managing docs, that stores the docs and related info in the database.
Nope. Record size limit is 32K, LOBs can store upto 1GB, among other differences.
Point is, records are designed to store info, in the traditional meaning of the word, and LOBs, well, large chunks of data.
mpowell_esq said:
I meant it as an example, i.e. store binary data e.g. images in BLOBs, and text e.g. XML in CLOBs.
For example, an archive app for managing docs, that stores the docs and related info in the database.
mpowell_esq said:
Nope. Record size limit is 32K, LOBs can store upto 1GB, among other differences.
Point is, records are designed to store info, in the traditional meaning of the word, and LOBs, well, large chunks of data.
mpowell_esq
Member
funny
LOB ;
Lot
Of
Binary
CLOB;
Corr
Lot
Of
Binary
I appreciate now the terms. How LOB and CLOB, hold file details (the binary breakDown of the file. 10011s ... How Word etc would hold the data)
LOB ;
Lot
Of
Binary
CLOB;
Corr
Lot
Of
Binary
I appreciate now the terms. How LOB and CLOB, hold file details (the binary breakDown of the file. 10011s ... How Word etc would hold the data)