Forums Register Login

store image using sql server

+Pie Number of slices to send: Send
hi,
i am the beginner of jsp and like to know which is the best data type to store the image and how to retrieve the image from sql server 2000.
thank you.
+Pie Number of slices to send: Send
This has nothing to do with JSPs. Moving to our JDBC forum...
+Pie Number of slices to send: Send
ES,
Welcome to JavaRanch!

You can store the image in a BLOB object. Search for "Blob" in this forum or the Sun JDBC tutorial for an example.
+Pie Number of slices to send: Send
Thanks Jeanne. But the sql server doesn't support blob data type. I try to store in image type but don't know how to retrieve in jsp page.
+Pie Number of slices to send: Send
SQL Server's image datatype is a blob.

As Jeanne suggested, take a look at the Sun JDBC tutorial for an example. The Java API javadoc will be helpful as well.
There's a way to do it better - find it. -Edison. A better tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1886 times.
Similar Threads
how to store an image object in the database
put image into database
Fetching Image Data
storing and retriveing image through Ms-sql
JDBC to SQL Server
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 03:41:37.