Each SQL column has a type that defines the accepted values and the space used: integers, exact decimals (NUMERIC), text (TEXT, VARCHAR), dates and times, booleans. A good choice avoids errors: amounts in NUMERIC rather than floating point, dates in a date type rather than text.
Example
prix NUMERIC(10, 2), cree_le TIMESTAMP