Hi

For one .. I understand mixing blobs with "other" data could have a
performance impact and two perhaps i makes my solution
kinda portable. I already have the solution working in postgresql as
text/varchar data is kinda universal

/M

>>> "Moegamat Alexander" <alexanderm@...> 2008-10-22 10:02 >>>

Hi

I have tried varchar ... but I ran to exactly what you saying here 32K
limit...
Im trying to decode binary files into txt using base64 which depending
on
the size of the files produces a kinda large text format which i want
to store into the database..
Varchar behaves a bit choppy in this regard and I think the answer is
in blob subtype text..
I would be nice if I can compress on the fly before storing ... so I
need to be carefull not to
add any major lag...

/M

>>> "Thomas Woinke" <thomas.woinke@...> 2008-10-21 14:49 >>>

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
>
>