--- In firebird-support@yahoogroups.com, Lester Caine <lester@...> wrote:
> W O wrote:
> > I know how to insert an image or photograpy to a table using a programming
> > language and how to see that image or photography, but I don't know how to
> > do without a programming language. So, I have two questions:
> > 1. How to insert an image or photography without using a programming
> > language?
> > 2. How to see that image or photography without using a programming
> > language?
>
> The quick answer is "you can't" ... I don't know if any of the management
> tools
> support images, Flamerobin doesn't.
>
SQL Workbench/J can handle that. It does not automatically detect the type of a
BLOB, but you can display the image "manually". It also can export/import BLOB
data e.g. through CSV files (the CSV file then contains the filename of the
blob data).
It also supports an "extended" SQL syntax where you can reference an external
file in an insert or update statement, e.g.
update foo
set img = {$blobfile=/foo/bar/image.png}
where id = 42;
http://www.sql-workbench.net
(I'm the author of that tool)
