--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:

>
> 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
> --
> Mark Rotteveel
>

thanks,i get to try.