Datatypes

• meiko

  Newbie

  Points: 1

  More actions

  February 19, 2002 at 3:07 pm

  #77789

  What are the equivalents of Accesses "text" and "number" datatypes in SQL Server? For the number field, I need to be able to specify the length.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 19, 2002 at 3:14 pm

  #424155

  Numeric for number, and varchar or char with a lenght of no more than 255 for the text.

  Nermic has a precision and scale in the for NUMERIC(p,s), p = to the total max lenght, and s = to the total digits left of the decimal.

  If you use a value in char or varchar greater than 255 the data stored in them will truncate.