List:General Discussion« Previous MessageNext Message »
From:Arul Date:May 30 2002 5:37am
Subject:Re: Alternate to varchar2
View as plain text  
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
>

Thread
MySQL Update Query with a JoinJoe Cherner30 May
  • Alternate to varchar2Arul30 May
    • Re: Alternate to varchar2Dan Nelson30 May
  • Re: Alternate to varchar2Arul30 May