Using BLOB columns

Wilton · Post by **Wilton** » Wed 22 Apr 2009 16:07

Hi,

I Try to use a BLOB colunm in my application, but when a try insert a .jpg image in this column i receive the message error "Bitmap image is not valid"

I don't understand, because it's happen.

This same error occours in MyDACDemo project, i'm only insert .bmp files.

My enviroment is:
MySQL server version: 5.0.67-community-log
MySQL client version: Direct
Borland® Developer Studio for Microsoft® Windows™ Version 10.0.2558.35231 Update 2
MyDAC Professional Edition Version 5.80.0.46 for Delphi 2006

Thanks for any help.

Dimon · Post by **Dimon** » Thu 23 Apr 2009 08:35

I can not reproduce the problem.
Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com, including a script to create and fill table.

Wilton · Post by **Wilton** » Thu 23 Apr 2009 11:58

Hi Dimon,

While i prepare an example, i would like to explain that this error occurs even with the MyDACDemo project (..\Devart\MyDac for Delphi 2006\Demos\Win32\MyDacDemo), it only accepts image files of type .bmp, any other type of picture it displays the error message described earlier and does not save the image in the BLOB field.

I tried to use the two read image methods LoadFromFile () and LoadFromStream () without success, only .bmp files are saved.

Thanks,

Dimon · Post by **Dimon** » Fri 24 Apr 2009 06:39

The problem is that the TDBImage component doesn't support .jpg images.