Re: Ingres questions followup

thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040) writes: >The question then comes up as to whether other major database vendors, in >particular Oracle, Informix and Sybase, have these same or similar limitations. >Also, what other limitations or potential traps may there be that I don't know >about. >Please post or cross-post any comments in comp.databases, as I don't read the >various subgroups. >Bill Thompson The version of Sybase we use here has limit of 1962 bytes per row. However, I believe this applies to fields that are not declared as type TEXT. TEXT fields, which can hold up to a little over 2 billion bytes take up only about 10 bytes against the limit just mentioned. I have found, though, that text fields have to be used judiciously as all you have to do is store say 1 character in a TEXT field and Sybase will allocate something like 2K bytes. -- -- Wolfgang Richter (e-mail: wolfgang@sfu.ca) -- Academic Computing Services -- Simon Fraser University -- Burnaby, B.C. -- Canada V5A 1S6 -- Phone: 604-291-4449