Re: 1 Byte Integer Type ?

Bernhard Derix wrote: > > Why is there no 1-Byte Integer Type in Informix, or is there ? > Smallint is 2 Bytes. > > -- > Bernhard Derix > email: derix@forwiss.uni-passau.de > Homepage: http://www.forwiss.uni-passau.de/~derix/ > Universitaet Passau, FORWISS, Zi. FMI 034, Innstr. 33, 94032 Passau > Tel.: 0851/509-3144 There is no 1-byte integer type. I don't know why. But I do know that it's not much of a problem unless you have really huge amounts of data. Disks just keep getting bigger and faster. Try this: CREATE TABLE mytable ( mycol SMALLINT, CHECK (mycol BETWEEN -254 AND 255) CONSTRAINT mycol_1byte ) --Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/