Re: Restricting the size of a BLOB column

From: Justin Cave <jcave_at_cableone.net>
Date: Wed, 19 Mar 2003 10:18:36 -0700
Message-Id: <24715.322399@fatcity.com>

At 01:53 AM 3/19/2003, Naveen Nahata wrote:
>Hi All,
>
>Apologies if this question is naive.
>
>How to restrict the size of a BLOB column? I mean the column is defined as
>BLOB, and I want data not more than lets say 100KB to be in it, how to
>achieve this?

I believe you should be able to put a check constraint on the table that looks at the number of bytes in the column. You could certainly do this with a trigger, but the constraint makes more sense to me.

Justin Cave
Justin Cave
Distributed Database Consulting Received on Wed Mar 19 2003 - 11:18:36 CST