Re: BLOB Datatype question ?

Sudhir Nair wrote: > > }Date: Thu, 13 Feb 1997 11:13:28 -0800 > }To: informix-list-owner@rmy.emory.edu > }From: Sudhir Nair <sudhirn@dg85.fourgen.com> > }Subject: BLOB Datatype question ? > } > }Does anybody know of a built in function or have written a function to > find out the content of a byte column. I have a byte column that couldhold > either text or binary data (like voice, picture,etc). Is there a way to find > out if the data in that column is a text or binary(picture, voice,etc). As far as I know, BLOB data types in OnLine are very limited when it comes to accessing them or processing them. You can only insert or select a BLOB data column. I believe Universal Server has what you are looking for (datablades). My suggestion would be to put a signature at the top of the file/data and retrieve the whole BLOB column and let an external process (C/C++) analyze it and process it accordingly. Good luck Arun