Re: Sizing of char,varchar and text fields

In article <412gpi$i50@sclinux.blm.gov> Gary Slagel <gslagel@sc.blm.gov> writes: >From: Gary Slagel <gslagel@sc.blm.gov> >Subject: Sizing of char,varchar and text fields >Date: 18 Aug 1995 16:57:22 GMT >I'm trying to figure out the best way to handle some large fields in my >database. VARCHAR would be perfect if it didn't have that 256 char limit. >CHARACTER is plenty long (32000) but I don't want it taking up 32000 bytes >every >time I put a 10 character name in the field. >How about TEXT???? I can't find out for sure how much room text fields take. >I heard a rumor that they take up 2K of space as soon as you put in a 10 char >name. Is that true? >Are there any clever solutions out there? The type TEXT is a BLOB. It does not necessarily have to be allocated in the table. It can be elsewhere. What type of data will the field contain? Why is the range so large (10 bytes to 32000)? Michel Behna - mbehna@promus.com DoD #1821 - Suzuki Katana 600