What is it exactly a BLOB in a DBMS context

BLOB :

BLOB (Binary Large Object) is a large object data type in the database system. BLOB could store a large chunk of data, document types and even media files like audio or video files. BLOB fields allocate space only whenever the content in the field is utilized. BLOB allocates spaces in Giga Bytes.

USAGE OF BLOB :

You can write a binary large object (BLOB) to a database as either binary or character data, depending on the type of field at your data source. To write a BLOB value to your database, issue the appropriate INSERT or UPDATE statement and pass the BLOB value as an input parameter. If your BLOB is stored as text, such as a SQL Server text field, you can pass the BLOB as a string parameter. If the BLOB is stored in binary format, such as a SQL Server image field, you can pass an array of type byte as a binary parameter.

A useful link : Storing documents as BLOB in Database – Any disadvantages ?

Related Posts:

  1. ORA-00904: invalid identifier
  2. How do I reset a sequence in Oracle?
  3. MySQL equivalent of DECODE function in Oracle
  4. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  5. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  6. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  7. Self Join to get employee manager name
  8. how to fix oracle ORA-01722 invalid number error
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. ORA-00979 not a group by expression
  11. ORA-00907: missing right parenthesis
  12. Why do we need “Relationships” between tables at all?
  13. Case statement in MySQL
  14. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  15. ORA-01843 not a valid month- Comparing Dates
  16. ORA-00918: column ambiguously defined in SELECT *
  17. Oracle error : ORA-00905: Missing keyword
  18. How do I limit the number of rows returned by an Oracle query after ordering?
  19. Oracle SELECT TOP 10 records
  20. Can a foreign key be NULL and/or duplicate?
  21. How to Select Top 100 rows in Oracle?
  22. ORA-12560: TNS:protocol adaptor error
  23. What is the difference between JOIN and UNION?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. ORA-00972 identifier is too long alias column name
  26. Oracle Apex column link from LOV values
  27. PLS-00103: Encountered the symbol when expecting one of the following:
  28. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  29. ORA-00918: column ambiguously defined in SELECT *
  30. ORA-00918: column ambiguously defined in SELECT *
  31. how to drop partition without dropping data in MySQL?
  32. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  33. ORA-01861: literal does not match format string
  34. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  35. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  36. How do you create a temporary table in an Oracle database?
  37. Oracle “Partition By” Keyword
  38. How to insert date values into table
  39. Oracle SQL: Update a table with data from another table
  40. Oracle SQL query for Date format
  41. The backend version is not supported to design database diagrams or tables
  42. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  43. SQL selecting rows by most recent date with two unique columns
  44. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  45. Postgres Error: More than one row returned by a subquery used as an expression
  46. Comparing Dates in Oracle SQL
  47. Convert timestamp to date in Oracle SQL
  48. Update statement with inner join on Oracle
  49. what is the difference between triggers, assertions and checks (in database)
  50. Oracle: If Table Exists
  51. DATEDIFF function in Oracle
  52. How to create id with AUTO_INCREMENT on Oracle?
  53. LEFT function in Oracle
  54. Solutions for INSERT OR UPDATE on SQL Server
  55. What is the difference between Views and Materialized Views in Oracle?
  56. How do I view the Explain Plan in Oracle Sql developer?
  57. ORA-01779: cannot modify a column which maps to a non key-preserved table
  58. “select * into table” Will it work for inserting data into existing table
  59. ORA-01735: invalid ALTER TABLE option – Toad
  60. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  61. Conversion failed when converting date and/or time from character string while inserting datetime
  62. QL Error: ORA-00933: SQL command not properly ended
  63. error, string or binary data would be truncated when trying to insert
  64. Using group by on multiple columns
  65. How to declare a variable in MySQL?
  66. How do I escape a single quote in SQL Server?
  67. SELECT DISTINCT on one column
  68. TSQL PIVOT MULTIPLE COLUMNS
  69. MySQL – UPDATE multiple rows with different values in one query
  70. How to create a MySQL hierarchical recursive query?
  71. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  72. Subtract one day from datetime
  73. Backup a single table with its data from a database in sql server 2008
  74. updating table rows in postgres using subquery
  75. Is there a coalesce-like function in Excel?
  76. SQL query to extract only the “current” wp_posts?
  77. Organizing WP Pages based on old website database
  78. How to retrieve sticky post in raw sql?
  79. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  80. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  81. $wpdb get_var issue
  82. Inserting rows into a custom table, when plugin is activated
  83. WordPress is not creating table in database after activating plugin,
  84. Prevent duplicate records in plugin table
  85. delete duplicate comments
  86. WPDB SQL query with prepare() returning variable, not db value
  87. Posts modified in the last 48 hours
  88. Why this query is not showing any result on wordpresss home page?
  89. How to migrate a database from a server to another
  90. How to display data from db in select list [closed]
  91. post id not displaying
  92. Bulk find & replace on WordPress posts/pages (minus image paths)
  93. Correct and secure way to access a custom SQL database in a custom PHP template file
  94. Insert multiple checkbox values
  95. Querying multiple meta_keys in WordPress SQL query
  96. Getting deleted users in database
  97. How to get EVENT based on startday, using BETWEEN
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. SQL query to rewrite all media URLs to end with .webp
  100. Weird WP -Cli Error Connection Refused

Leave a Comment