tinyint, why not smallint or int2?

Martín Marqués martin@bugs.unl.edu.ar
Mon, 12 Nov 2001 20:14:27 -0300


I'm looking at the category.sql, and I see that there are tinyint data types, 
which I can guess that are MySQL's equivalent to INT2 or SMALLINT.
Can't this be compatible to all databases? I think that MySQL supports 
SMALLINT, as well as PostgreSQL an Informix (those are the ones I know).

I also see that there is an ALTER TABLE to add an index, when it should only 
be a CREATE INDEX statment.

Do the fellows see it OK?

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------