mohan@ihlpf.ATT.COM (Mohan Palat) (03/12/88)
Info on the advantages of the TEXT data type in Ingres ------------------------------------------------------ Does anyone know the advantages of using the text data type instead of the character data type? As far as storage space is concerned, each text field takes an additional 2 bytes over an identical character field. Tests run with text and character fields seem to indicate that retrieves are, in general, faster with a character field than with a text field. Of course, text fields are useful when comparing strings, since blanks are not ignored, and also for defining character fields that are greater than 255 characters. Mohan Palat AT&T (ihnp4!ihlpf!mohan) -- MOHAN PALAT
shapiro@wdl1.UUCP (David Shapiro) (03/15/88)
/ wdl1:comp.databases / mohan@ihlpf.ATT.COM (Mohan Palat) / 1:48 pm Mar 11, 1988 / >> Info on the advantages of the TEXT data type in Ingres >> ------------------------------------------------------ >> >> Does anyone know the advantages of using the text data type >> instead of the character data type? As far as storage space As far as I know, the only advantage is in the forms system. There you can have a large text field with some wrap around on the lines. We have, however, also noticed that retrieves on text are slower than on char types. Most of the time we use a table field with a table field text editor to give some editing capabilities. David Shapiro Ford Aerospace Corp. Western Development Laboratories shapiro@ford-wdl1.arpa ...{sgi,sun,ucbvax}!wdl1!shapiro All opinions stated here are my own, not my employer's.