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

why aren't you just storing in binary (in a binary blob), it's probably far
more efficient than first converting to base64
Alan