| Author |
Image insertion into database
|
Gvn Karthik
Greenhorn
Joined: Feb 07, 2011
Posts: 22
|
|
I have Oracle 10g Express Edition installed. I'm not able to insert images into the database of size greater than 3kB. I want to insert images of higher sizes say 200kB.
When I checked the size of the image column which is of BLOB type, the size turned out to be 4000. That explains why I was not able to insert an image of higher size.
How do I increase the size of the BLOB field so that I can store bigger images?
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26195
|
|
|
Oracle 10g allows up to 4 gigabytes in a BLOB. The express edition is a different product though and might not allow big files at all.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
Blaidd Gwael
Greenhorn
Joined: Oct 01, 2009
Posts: 13
|
|
|
Have you read: Oracle ?
|
|
Gvn Karthik
Greenhorn
Joined: Feb 07, 2011
Posts: 22
|
|
I read the stuff from the links above but I could not create the table successfully. How should I modify the following query to suit larger image insertion?
create table images(imageid number(10), photo blob);
|
|
 |
|
|
subject: Image insertion into database
|
|
|
0
