How do I insert a blob in SQL

∟Reference Citations in 2021

∟How do I insert a blob in SQL

'Inserting BLOB Values with SQL INSERT Statements' tutorial was cited in a pretagteam.com post in 2021.

The Inserting BLOB Values with SQL INSERT Statements tutorial was cited in a pretagteam.com post in 2021.

Subject: How do I insert a blob in SQL
Date: 2021-09-21
Author: Pretag
Source: https://pretagteam.com/question/how-do-i-insert-a-blob-in-sql

The simplest way to insert a binary string into a BLOB column is to use a SQL
INSERT statement and include the binary string a SQL binary literal in the
statement as shown in this sample program. Note that SQL binary literal format
is '<hex_numbers>'.,Notice that the binary literal format on Oracle is different
than MySQL. This is another reason that you should avoid using binary literals
in SQL statements to make your Java program portable.,Using SQL binary literals
to insert BLOB values into a database is simple, but it requires you to convert
your binary data into the SQL binary literal format: '<hex_numbers>', which
could be a problem if you have a very long binary data to enter.,The compilation
and execution of this program are shown below. The output confirms that the
character string value was correctly inserted into the BLOB column:

The simplest way to insert a binary string into a BLOB column is to use a SQL
INSERT statement and include the binary string a SQL binary literal in the
statement as shown in this sample program. Note that SQL binary literal format
is '<hex_numbers>'.

/* OracleBlobInsert.java
 - Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class OracleBlobInsert {
   public static void main(String[] args) {
      Connection con = null;
...