Question!!! About Store Image ... HELP!!!

Question!!! About Store Image ... HELP!!!

Post by Keven Wan » Wed, 04 Nov 1998 04:00:00



Hi!

I have some image file which want to store in MSSQL 65, but I got a failed.
After I saved my image file, I find SQL 'Cut off' some of the picture. I
checked
the table setting and I found the size of column of picture just only 16.
What's
happened to me? Why can't I store the image file about 20K in SQL ?

Does anyone help me?
Thanks a lot.

 
 
 

Question!!! About Store Image ... HELP!!!

Post by Dan Guzma » Wed, 04 Nov 1998 04:00:00


MSSQL Server 6.5 stores images as a pointer to a group of chained 2K pages.
The text pointer is reported as 16 bytes.

Hope this helps


>Hi!

>I have some image file which want to store in MSSQL 65, but I got a failed.
>After I saved my image file, I find SQL 'Cut off' some of the picture. I
>checked
>the table setting and I found the size of column of picture just only 16.
>What's
>happened to me? Why can't I store the image file about 20K in SQL ?

>Does anyone help me?
>Thanks a lot.


 
 
 

1. Store image by using image datatype in SQL 7.0

Hi all,

     I have read the mail which the subject is HOW TO USE THE BINARY OR THE IMAGE
DATATYPE. I find the method which is provided by Neil Pike. Unfortunately I have
problems in getting the image from table. How can I get the image size or file
length in the table. I have used "GETCHUNK" method but I cannot locate the image
in the table.

Please help me to solve this problem

Regards,
CY

2. Replace function.

3. Displaying images stored in an Image field from an ASP

4. A check for Corrupt Indexes

5. Storing Image into a Database image field

6. ADO Session Pooling Question

7. store image, or image path in DB?

8. table scan

9. Store an image file into an image type column

10. Store an image file into an image type column from a Windev program

11. Image datatype, and storing images in SQL server

12. Storing images or pointers to images - advice please

13. Need help storing large text and images into SQL Server 6.5