Subject RE: [ib-support] Equivalent to TEXT field
Author Darryl VanDorp
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.


-----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
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
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.
is a know problem and will hopefully be fixed sometime soon. In the
large varchars can cause a lot of traffic.

Neither field type can be indexed. You may want to look at this link for a fuller discussion of when and
how to choose between the two.


Paul Reeves
taking InterBase further

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to