MySQL Forums
Forum List  »  Oracle

Re: What would be varchar2(4000) in mySQL ??????
Posted by: Josh Chamas
Date: September 22, 2004 07:46AM

Hi Ben,

I would recommend the TEXT type, which is a field that has character semantics. The BLOB type is better for raw binary data. Future stable versions of MySQL, say 4.1.x, will also have things like UTF8 character semantics for things like TEXT implemented as well, but right now what you get is things like case insensitive sorting. Also, you can put an index on a TEXT column by using an index prefix like:

create table text_test (
text_field TEXT NULL,
INDEX( text_field(255) )
)

Regards,

Josh



Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
19170
September 21, 2004 02:23AM
Re: What would be varchar2(4000) in mySQL ??????
9779
September 22, 2004 07:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.