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