Subject Re: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column?
Author Mark Rotteveel
On 31-3-2013 17:23, wan30032 wrote:
> hello,now i used type is smallint.
> but there are more than 4,000,000,000 records.
> so i want to change with like ms sql tinyint.

For binary data you can use (VAR)CHAR with character set OCTETS. So if
you want to store one byte use: CHAR(1) CHARACTER SET OCTETS

Mark Rotteveel