Sample Header Ad - 728x90

What is charset for a Blob?

0 votes
1 answer
30 views
I'm looking at [Oracle Database Sample Schemas](https://github.com/oracle-samples/db-sample-schemas) , and found there is a column of a charset for a column of Blob. https://github.com/oracle-samples/db-sample-schemas/blob/main/customer_orders/co_create.sql#L105
-- Details of goods that customers can purchase

-- auto-generated definition
create table PRODUCTS
(
    PRODUCT_ID         NUMBER generated by default on null as identity
        constraint PRODUCTS_PK
            primary key,
    PRODUCT_NAME       VARCHAR2(255 char) not null,
    UNIT_PRICE         NUMBER(10, 2),
    PRODUCT_DETAILS    BLOB
        constraint PRODUCTS_JSON_C
            check (product_details is json),
    PRODUCT_IMAGE      BLOB,
    IMAGE_MIME_TYPE    VARCHAR2(512 char),
    IMAGE_FILENAME     VARCHAR2(512 char),
    IMAGE_CHARSET      VARCHAR2(512 char),
    IMAGE_LAST_UPDATED DATE
)
/

comment on table PRODUCTS is 'Details of goods that customers can purchase'
/

comment on column PRODUCTS.PRODUCT_ID is 'Auto-incrementing primary key'
/

comment on column PRODUCTS.PRODUCT_NAME is 'What a product is called'
/

comment on column PRODUCTS.UNIT_PRICE is 'The monetary value of one item of this product'
/

comment on column PRODUCTS.PRODUCT_DETAILS is 'Further details of the product stored in JSON format'
/

comment on column PRODUCTS.PRODUCT_IMAGE is 'A picture of the product'
/

comment on column PRODUCTS.IMAGE_MIME_TYPE is 'The mime-type of the product image'
/

comment on column PRODUCTS.IMAGE_FILENAME is 'The name of the file loaded in the image column'
/

comment on column PRODUCTS.IMAGE_CHARSET is 'The character set used to encode the image'
/

comment on column PRODUCTS.IMAGE_LAST_UPDATED is 'The date the image was last changed'
/
What would be the IMAGE_CHARSET column for? > comment on column PRODUCTS.IMAGE_CHARSET is 'The character set used to encode the image' Do we need a charset for storing image bytes to the PRODUCT_IMAGE column?
Asked by Jin Kwon (165 rep)
May 6, 2025, 05:57 AM
Last activity: May 7, 2025, 07:22 AM