Hi,

you could use varchar, which can be up to 32000 chars wide, or blob
sub_type text (known as CLOB in other DBMS), which basically has no
size limit.
Here's an article to help decide when to use which:
http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm


/thomas

On Tue, Oct 21, 2008 at 2:35 PM, Moegamat Alexander
<alexanderm@...> wrote:

> Hi
>
> Which data type can I use for variable data size ... I need to store
> quite large text data in the database.
>
> Many thanx
>
> M
>
>