sql field types

aron

Does anyone know where i can get a complete list of all field types with examples of how they are used.

name varchar(255)

just that im not used to sql database.

aron.

waltherjt

Here,

Try this. I still need someone to explain it to me, ie what are the benefits of using one type over another.

http://www.mysql.com/doc/en/Column_types.html

Cheers!

Sxooter

Do you want SQL92 standard data types?

If you want to see the sql 92 standards, look at this file:

http://epoch.cs.berkeley.edu:8000/sequoia/schema/STANDARDS/SQL3/sql1992.txt

The standard data types for SQL92 are:

CHARACTER, CHARACTER VARYING, BIT, BIT VARYING, NUMERIC, DECIMAL,
INTEGER, SMALLINT, FLOAT, REAL, DOUBLE PRECISION, DATE, TIME,
TIMESTAMP, and INTERVAL

Anything else is database specific and should be avoided.