How do you handle binary blobs? Give the programmer the responsability if
he/she converted inadvertently them to char/varchar?

AFAIK, there's no real distinction in the server between SUB_TYPE 1,2 and
others, but probably for consistency, TEXT blobs could be converted to char
implicitly but no other types.

I suggest the importance of being able to apply the subscript operator [] to
strings and maybe, blobs or in its defect, the substr function, even if I
have to address one character with
substr(s,pos,1) every time.

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://members.tripod.com/cvalde

> -----Original Message-----
> From: Jim Starkey [mailto:jas@...]
> Sent: Viernes 5 de Mayo de 2000 15:10
> At 12:00 PM 5/5/00 -0700, Markus Kemper wrote:
> >
> > I often wish for:
> >
> > cast( var | char as blob ) and cast( blob to var | char )
> >
> > Wouldn't that be handy?
> >
>
> Rather than a cast, why not just treat a blob as a character
> string?
>
> Jim Starkey