Re: Size of blob,clob

Posted in 2000

Obnoxio The Clown — Fri, 15 Sep 2000 14:54:14 BST — source: Informix-list mailing list archive (1991-1998)

From: Alessandro <busato@newtech.it> > >I need to know blob/clob size by using a SELECT statement, >do you know the query for solving this problem? > >(I work with IUS9.21) Gee, I don't know -- have you tried: SELECT LENGTH(clob) FROM table WHERE ... ? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

↪ replying to Obnoxio The Clown

Alessandro — Fri, 15 Sep 2000 16:54:50 +0200 — source: Informix-list mailing list archive (1991-1998)

I've the function length on html parameter type, I've tried select length(lld_lobsend(object)::clob::html) from table where id = nn; this solution works but the response time is as it count one byte at a time or like performing a file download, is there another way for it? Thanks, Alessandro Obnoxio The Clown wrote: > From: Alessandro <busato@newtech.it> > > > >I need to know blob/clob size by using a SELECT statement, > >do you know the query for solving this problem? > > > >(I work with IUS9.21) > > Gee, I don't know -- have you tried: > > SELECT LENGTH(clob) > FROM table > WHERE ... > > ? > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.