Hi Dan...
Oracle gives me the option for Varchar2(900)...
But mysql stops me at varchar(255)...
Is there any other alternate other than blob and text if i want that field t
contain around 1000 characters...
-Arul
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "Arul" <arulkumar@stripped>
Cc: <mysql@stripped>
Sent: Thursday, May 30, 2002 10:41 AM
Subject: Re: Alternate to varchar2
> In the last episode (May 30), Arul said:
> > I am trying to port my oracle Databse to mysql. I am using 3.23.49
> > version of mysql.
> >
> > i had certain columns in oracle which had varchar2(900)
> >
> > But in mysql varchar doesnt support more than 255
> >
> > so what could be the alternate in this case..
> >
> > Can i use Blob or text..But again if i use blob and if i use a like
> > condition in my query , it would be a performance problem.
>
> It'll be no worse than Oracle's performance in this case; they both
> store blobs away from the rest of the record afaik.
>
> Actually if you put a fulltext index on the text field and use that to
> search instead of using LIKE, mysql will be a lot faster than Oracle.
>
> --
> Dan Nelson
> dnelson@stripped
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread110483@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-arulkumar=calsoft.co.in@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
