From: gainer@gainer.engr.sgi.com (Patrick Gainer) Subject: Re: VARCHAR, WHY THE 2000 Character Limit ?? Date: 1995/11/30 Message-ID: <49kqil$db@fido.asd.sgi.com> X-Original-Message-ID: <49kqil$db@fido.asd.sgi.com>#1/1 X-Deja-AN: 120590486 references: <49794h$pof@carbon.cudenver.edu> <49dj7c$11m6@locutus.rchland.ibm.com> organization: Silicon Graphics, Inc., Mountain View, CA newsgroups: comp.databases,comp.databases.ingres,comp.databases.oracle,comp.databases.theory In article , Michael Leo wrote: >In article enduser@enduser.com (EndUser) writes: > >>there you will find a more than adequate facility. in other words. comparing >>like below is incorrect since you are looking in the wrong place for the answer. >>do not compare the datatypes. >> >>also, db2, ingres, and informix fall far short in the speed with which >>theyhandle >>large character fields. >> > >How did you do this comparison? Define "large". Please be more >specific. I don't understand what you are comparing. He is just being a dufus. From his comments it is clear he has not done much BLOB work. Oracle has just about the worst BLOB support of any of the big 3 RDBMS vendors. Informix and Sybase aren't too bad but upstart DB2/unix 2.1 is by far the best. I don't have the time or inclination to post a feature-by-feature comparison but I have looked at these products and there is a clear winner. Frankly, I'd be astonished if DB2/unix 2.1 didn't absolutely cream Oracle in BLOB manipulation speed *and* function. Pat