hello everyone...
could anyone tell me how to store images in oracle database..or which datatype has to use for it..
RvSon -3 Newbie Poster
Recommended Answers
Jump to PostMoved to Oracle forum.
Jump to PostPersonnally, I prefer to leave images on the network file server, than to store them in the database.
However, being a consultant, I pretty well have to do what my clients want.
Jump to PostIs it really necessary to store the images in the database? Like debasisdas pointed out, you can store the image as binary.
Maybe it's a good idea to store the images on the server and just make a reference to it's directory on the database.
Jump to PostStoring images themselves in a database sounds like a really bad idea, just store the server path.
All 14 Replies
debasisdas 580 Posting Genius Featured Poster
Convert the image into a binary stream and store in a BLOB field in oracle.
jbennet 1,618 Most Valuable Poster Team Colleague Featured Poster
Moved to Oracle forum.
hfx642
Personnally, I prefer to leave images on the network file server, than to store them in the database.
However, being a consultant, I pretty well have to do what my clients want.
debasisdas commented: agree +13
lgabrielmf 0 Newbie Poster
Is it really necessary to store the images in the database? Like debasisdas pointed out, you can store the image as binary.
Maybe it's a good idea to store the images on the server and just make a reference to it's directory on the database.
arshadshabbir 0 Newbie Poster
Use BLOB datatype to store image in database
jbennet 1,618 Most Valuable Poster Team Colleague Featured Poster
Storing images themselves in a database sounds like a really bad idea, just store the server path.
arshadshabbir 0 Newbie Poster
You are absolutely right JBENNET, but i just answered the question asked..........
RvSon -3 Newbie Poster
thanks a lot, but can u please tel hw to store server path in the database..
means is there any technique to convert?
jbennet 1,618 Most Valuable Poster Team Colleague Featured Poster
What?
Just store it as text!
I.e. upload the images themselves to your (web/ftp/whatever) server, then just store the path to them in the database.
e.g. the datatabase would hold something like "http://fileserver.mydomain/images/img1.jpg"
debasisdas 580 Posting Genius Featured Poster
No need to convert anything.
1. Create a directory in the server.
2. Create an Oracle directory for the server directory.
3. Store all the files in the server directory.
4. In the database store the file path as string and also the Oracle directory name.
hfx642
Technically, you don't have to store anything in the DB.
Put all of you images in one location on the network.
eg. /Production/My_System/Images
Name your image file with the record PK.
eg. 0123456.jpg
If there is ever a breach in security,
people's names are NOT show with the image.
yash_792 0 Newbie Poster
hello everyone...
could anyone tell me how to store images in oracle database..or which datatype has to use for it..
Hi you can store images in oracle by using datatype as Bfile. it has a capacity of 4 gb of filesize. Bfile stores Binary data of external file upto 4 gb.
Hope this helps.
debasisdas 580 Posting Genius Featured Poster
Using bfile is same as storing the path of the file in disc.
In this approach the problem is if the file is deleted or moved out of the specified oracle directory oracle will will be unable to retrieve the file and will throw an error.
saideepak89 0 Newbie Poster
k... then how to Convert the image into a binary stream .
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.