Subject Re: [firebird-support] Re: How to insert and see an image or photography?
Author W O
Thank you very much Thomas.

Are you the author of SQL Workbench? Congratulations, very good job!!!.

Greetings.

Walter.





On Wed, Dec 12, 2012 at 7:44 PM, Thomas <IJFQSFTGESJU@...> wrote:

> **
>
>
> --- 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)
>
>
>
>


[Non-text portions of this message have been removed]