Hello
On Tuesday, September 27, 2016 9:36 AM, "liviuslivius liviuslivius@poczta.onet.pl [firebird-support]" <firebird-support@yahoogroups.com> wrote:
W dniu 2016-09-27 08:06:13 użytkownik Mike Ro miker169@gmail.com [firebird-support] <firebird-support@yahoogroups.com> napisał:
On 27/09/2016 04:22, trskopo@yahoo.com [firebird-support] wrote:
Is it possible to insert image into FB database directly via sql stament using isql or flamerobin?
Hi, yes it is possible with FlameRobin.
- Insert a new record in the normal way (for example, right click on the table, select "Browse data" and Grid->Insert row).
- Now in the "Data" area of the window you will have a "[null]" in the column containing your blob field.
- Right click on this [null] and there will be an option "Import BLOB from file".
- Pick the image file you want to insert and the "[null]" will change to "[BINARY]".
- Commit the insert and the image should be in your database.
Note: If you want to view the image, right click on the "[BINARY]" text and choose "Save BLOB to file..."
Hope this helps.
Hi,
by clear SQL it is also possible for smaller images using hex notation
in FB3 command can by at 10MB length
regards,
Karol Bieniaszewski
__._,_.___
Posted by: <monteropetronilahvb@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment