MSSQL Image datatype VS. Paradox Graphics DataType

MSSQL Image datatype VS. Paradox Graphics DataType

Post by Denny Chua » Sat, 31 May 1997 04:00:00



I'm using the following code to load BMP images to Paradox Database.
This same code is not working at all under MSSQL when I have the
datatype as images.

  If (OpenDialog1.Execute) then
    begin
    table2.edit;
    {user pressed OK! }
    DBImage2.Picture.LoadFromFile(OpenDialog1.FileName);
    table2.post;
    end;

I'm suspecting that MSSQL requires to actually store the entire
graphic data into the DB.  :-(  I'm not sure... Anyways, if you know
what I'm missing or doing wrong please advice!

Thank you very much for your help!


 
 
 

1. convert image datatype to text datatype

I am trying to convert ASCII based data in a image field
to text. I am able to use the convert function to convert
in to varbinary(8000), then to varchar(8000), and this is
working - mostly. Except, when it finds line return and
tab characters. In place of those characters, I am getting
a "-J", "-K", or something similar. Is there a way to
successfully these these hexidecimal characters?

2. IMP-00020

3. Conversion of Text datatype to Image datatype

4. Please help I have tried everything!!! Update a dbase table from a dataGrid control, How?

5. All text datatypes vs. more specific datatypes

6. CA-San Diego-263772--PL/SQL-ORACLE-UNIX-Junior Software Engineer

7. Help:Saving Graphic Image Into A BLOB Graphic Field In Paradox Table

8. psql hangs when trying to access a database

9. Image datatype, and storing images in SQL server

10. Maximum Image size allowed for Image Datatype

11. Maximum Image size allowed for Image datatype.

12. Store image by using image datatype in SQL 7.0

13. Graphic Datatypes