I've read Ivan's excellent document at the link given,
however, my biggest problem is inserting and select'ing.
If FB has solved most of these headaches this is GREAT!
(inserting but not select'ing if i'm reading correctly)

As for middleware, i'm developing some web stuff and
am using ADODB and it doesn't seem to do anything
special to extract blob's from simple select statments.

-Darryl


-----Original Message-----
Darryl VanDorp wrote:

I'd say Blobs are the way to go. Much of the headache with using Blobs has
gone from Firebird. There is now support in the engine to automatically
convert strings to blobs when doing inserts and updates. I'm not sure if
there
is a limit on how long the string can be. For instance, if a script is used
there might be a limitation in ISQL on statement length.

Of course, there is still the issue of extracting the data back out from a
blob. But that shouldn't be too difficult. Most middleware that I can think
of
can read blobs.

The main reason I can think of for not going the VarChar route is that
Varchars are sent fully padded to their maximum size across the network.
This
is a know problem and will hopefully be fixed sometime soon. In the
meantime,
large varchars can cause a lot of traffic.

Neither field type can be indexed. You may want to look at this link
http://www.volny.cz/iprenosil/interbase/ for a fuller discussion of when and
how to choose between the two.
Paul


--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/