How to Store a Bitmap Images into MSSQL field from Delphi
Posted on 2004-11-23
I am using Delphi 7 with MS-SQL 2000 database. I want to use BDE or ADO connection to store a bitmap into a database field. My bitmap file size is usually 200kb.
I created a field as IMAGE type in database. and I used the following to insert my bitmap into it:
//query1bitmapfield is a TBlobField
The previous works fine with bitmaps smaller that 32kb size.
Is there any solution to store my 200kb images into a database field? and how to do this?
what field type is suggested to be used?