From: mal@winternet.com (Michael Leo) Subject: Re: VARCHAR, WHY THE 2000 Character Limit ?? Date: 1995/11/30 Message-ID: X-Original-Message-ID: #1/1 X-Deja-AN: 120482901 distribution: world references: <49794h$pof@carbon.cudenver.edu> <49a8b8$546@news1.wolfe.net> organization: StarNet Communications, Inc newsgroups: comp.databases,comp.databases.ingres,comp.databases.oracle,comp.databases.theory In article enduser@enduser.com (EndUser) writes: > >wrong. the varchar 2000 is actually upgraded from earlier sizes of 255. >if you want to store large, gigabytes of chars, use long and long raw in oracle. I believe even University Ingres used the 2K page size. I've used commercial Ingres since 3.x, and it always had 2K page size. I don't find any references to the 512 pages size in the Stonebraker book "The Ingres Papers" either. >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. Cheers, |--------------------------------------------------------------------------| | Michael Leo | The Ingres FAQ is at ftp.adc.com, /pub/ingres. | | York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for | | Minneapolis, MN, USA | the NAIUA Tool Kit. Lastly, access all this via| | (612) 921-8083 (voice) | WWW at http://www.adc.com/ingres/ing-top.html. | | mal@winternet.com | All constructive suggestions/criticism welcome. | |--------------------------------------------------------------------------|