One Byte signed Integer

Posted in 2004

Carlos San Miguel — 17 Apr 2004 06:50:23 -0700 — source: Usenet: comp.databases.informix

Is there a one byte signed integer variable type in Informix SQL? I've read several of the informix manuals and can't seem to find one. I see there is INT and SMALLINT only. TIA Carlos San Miguel

↪ replying to Carlos San Miguel

Jonathan Leffler — Sat, 17 Apr 2004 21:14:01 GMT — source: Usenet: comp.databases.informix

Carlos San Miguel wrote: > Is there a one byte signed integer variable type in Informix SQL? I've > read several of the informix manuals and can't seem to find one. I see > there is INT and SMALLINT only. No - SMALLINT (2 bytes) is the smallest pure integer type. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler

scottishpoet — 17 Apr 2004 18:41:17 -0700 — source: Usenet: comp.databases.informix

Theoretically, couldn't someone write a UDT of their own to implement a one byte signed INTEGER? And if they thought other people might find it useful they could post it on the IIUG site? Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<t6hgc.14359$A_4.2626@newsread1.news.pas.earthlink.net>... > Carlos San Miguel wrote: > > > Is there a one byte signed integer variable type in Informix SQL? I've > > read several of the informix manuals and can't seem to find one. I see > > there is INT and SMALLINT only. > > No - SMALLINT (2 bytes) is the smallest pure integer type.

↪ replying to scottishpoet

Jonathan Leffler — Sun, 18 Apr 2004 02:49:49 GMT — source: Usenet: comp.databases.informix

scottishpoet wrote: > Theoretically, couldn't someone write a UDT of their own to implement > a one byte signed INTEGER? > > And if they thought other people might find it useful they could post > it on the IIUG site? Yes - a UDT could be written. It might be an interesting exercise to do so, especially considering the number of implicit conversions that might be needed. > Jonathan Leffler <jleffler@earthlink.net> wrote: >>Carlos San Miguel wrote: >>>Is there a one byte signed integer variable type in Informix SQL? >>>[...] I see there is INT and SMALLINT only. >> >>No - SMALLINT (2 bytes) is the smallest pure integer type. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/