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
Subject
Views
Written By
Posted
19268
September 21, 2004 02:23AM
Re: What would be varchar2(4000) in mySQL ??????
9826
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.