Re: One byte integer

On 25 Mar 2013 07:12, Raul A. Jager W. wrote:

In RPG (and other languages) I can declare a 1 Byte number, signed
for -128 to 127 and unsigned 0 to 255, which will be something
like a "half small integer".

But I could not find a way to define such a field in SQL. Is it
possible?

Depending upon actual requirements, the desired effects may be achieved with the SQL, using a CHECK CONSTRAINT. For example, the following ensures the values are within the specified bounds, even though the data type for its implementation remains a 2-byte integer:

create table dltmeint
( byteint smallint
, constraint "8bitInteger" check(byteint between -128 and 127)
)
;
insert into dltmeint values
( -2**7 ), ( 2**7 -1 )
;