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
Last activity: May 7, 2025, 07:22 AM