Path: utzoo!mnetor!uunet!seismo!sundc!pitstop!sun!wdl1!shapiro
From: shapiro@wdl1.UUCP (David Shapiro)
Newsgroups: comp.databases
Subject: Re: Ingres 5.0 - usefulness of the text data type ???
Message-ID: <3560007@wdl1.UUCP>
Date: 15 Mar 88 02:03:32 GMT
References: <3978@ihlpf.ATT.COM>
Lines: 23

/ 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.