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" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
