Entering images into iAnywhere with Sybase Central

[Robert Huber]

Hello All

May be it's obvious, but I still didn't manage to put some images into the database with Sybase Central. How is it done? What files are supported (.tiff, .png. jpeg, ....)?

Thanks a lot for a hint.

Best regards, Robert

[cybersack]

Hi Robert.

From your post, I can guess that either of 2 things are hppening:
1. your Servoy Form won't allow you to import the image types you want
2. your Sybase database won't accept them

#2 is definitely out of the question. It's just a BLOB or CLOB field.
#1 is probable because only JPG, GIF and PNG are supported with the Servoy Image Labels.

If #1 is your issue, then you could try our ImageBean plugin.
It currently supports Bitmap and we are right now implementing for TIF.

[Robert Huber]

Hi S (sorry, don't know your name)

Thanks for reply, obviously, I did not formulate very well as you have to guess about my question.

My question is just how to put some images, preferably as .png file, or, if not supported by Sybase, any other supported image format into a database field.
I have a field called icon and would like to put manually with Sybase Central (or Interactive SQL) an image into the field. I can interactively edit and create new records with Sybase Central, but did not find out how to fill an image field and what formats are supported.

Best regards, Robert

Hi Robert.

From your post, I can guess that either of 2 things are hppening:
1. your Servoy Form won't allow you to import the image types you want
2. your Sybase database won't accept them

#2 is definitely out of the question. It's just a BLOB or CLOB field.
#1 is probable because only JPG, GIF and PNG are supported with the Servoy Image Labels.

If #1 is your issue, then you could try our ImageBean plugin.
It currently supports Bitmap and we are right now implementing for TIF.

[Westy]

...My question is just how to put some images...into a database field...

If you want to put images in Sybase from within Servoy see:
http://forum.servoy.com/viewtopic.php?t=1005

[Robert Huber]

Hi Westy

I would like to put images interactively into the db from within Sybase Central, not from within Servoy.
Although I'm sure I have the below requirement at some point of development.

Best regards, Robert

...My question is just how to put some images...into a database field...

If you want to put images in Sybase from within Servoy see:
http://forum.servoy.com/viewtopic.php?t=1005

[david_jonker]

Hi Robert,

You can load images into the database using Sybase Central
if the image is stored on the same computer as the database.

Start Sybase Central. From within the "directory listing" in the
left-hand "Folder" pane, right-click on the table that will store the
images and select "View Data within Interactive SQL".

This will start the Interactive SQL utility. Within the
"SQL Statements" pane of Interactive SQL type:

INSERT INTO table1 ( column1 )
SELECT xp_read_file( 'c:\file_location\portrait.gif' )

This should work.

David