Subject Re: [firebird-support] Converting a JPEG to a blob...
Author Martijn Tonies
> Since there is no support for file types as data types, I was trying
> to convert a jpeg to a blob, I've gotten this to work with other dbms
> before, before I run the insert query I'm running through a script to
> double up all the ', but it's giving me an error when I execute the
> query it tells me there are illegal characters, so I was wondering if
> i should also parse the file and remove any carriage returns and what
> have, because from what I understand there are no escape characters in
> firebird... any suggestions for this? and another question somewhat
> off topic is the daily digest working, I stoped receiving the group
> emails??

Firebird only supports direct blob inserts into text blobs, not binary data.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!