--- In firebird-support@yahoogroups.com, "Mohd. Jeffry"
<linuxlah@g...> wrote:

> Thanks for the advice. So, what If I want to use jsp/servlet? Any
> other hint? TQ in advance
>
>
> On Thu, 27 Jan 2005 02:05:08 -0000, vandy899 <vandy899@y...> wrote:
> >
> >
> > --- In firebird-support@yahoogroups.com, "Mohd. Jeffry"
> > <linuxlah@g...> wrote:
> > > Which one is more suitable for replacing MySQL "longtext" data type?
> > > blob subtype text or varchar(32000) ? I want to use this field as a
> > > place to put my text rants at my blog application. This is another
> > > MySQL to Firebird migration issue.
> >
> > I'd say a blob of text subtype. You'll notice that varchar (n) puts a
> > rather arbitrary limit on whatever you're using. You will, however,
> > need to use the appropriate APIs to get stuff out of it - if you're
> > using PHP, look at the PHP documentation, if you're using Python, look
> > at the kinterbasdb documentation.
> >
> > Cheers,
> >
> > Michael
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >

It seems from others that it converts to Clob data type from the faq
(http://firebird.sourceforge.net/index.php?op=devel&sub=jdbc&id=faq),
but don't quote me on that - I haven't had a great deal of cause to
use it... :)