Re: Storing photos - I'm looking for advice.

Posted in 2003

Alejandro — 4 Dec 2003 05:45:56 -0800 — source: Usenet: comp.databases.informix

Well, these day I've working with photos of students on my IDS 2000 on Windows NT 4 and Power Builder 7.x. You can store the images as blob data type in the database. First you must to insert the row, and then, from power builder read the archive which has the image (jpg, bmp, etc..) convert it to a blob variable and then do the next sentence to store it: blob lb_picture ..... UPDATEBLOB table_with_blob_column set picture = :lb_picture WHERE ....; That's all! I'm working with IDS 7.3x and IDS 2000 9.2x on Windows NT and W2000