Database Administration (MOSC)

MOSC Banner

difference between blob and long raw

edited Jan 30, 2012 1:23AM in Database Administration (MOSC) 4 commentsAnswered

I am going to create a table to store employee images in a table called emp

emp will contain a lot of column's to store the data of the employees and a column for employee image (in the format of JPG file)

when I create the table, which data type do you prefer for the column of the  employee image

Blob or Long Raw

please also I want to know the diference between them.

which is the recent, which of them compress the image to don't effect of the table size.

thanx in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center