On Sun, Mar 31, 2013 at 11:23 AM, wan30032 <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.
>
>

I think what you want is :

CHAR[1] Character Set Octets

Don't use VARCHAR[1] - that will make each one three bytes long. And be
careful of the layout of your records. For example, if you sandwich your
CHAR[1] between two integer columns, you'll get three bytes of padding so
the integers align on natural boundaries.

Good luck,

Ann


[Non-text portions of this message have been removed]