Subject | Re: [firebird-support] Re: How to insert and see an image or photography? |
---|---|
Author | W O |
Post date | 2012-12-13T11:25Z |
Thank you very much Thomas.
Are you the author of SQL Workbench? Congratulations, very good job!!!.
Greetings.
Walter.
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]