Friday, February 24, 2012

Data Types

Hello, I am following this article about building an ASP.Net application which uses SQL Express 2005. The document calls for building a couple of tables. One column is identified with data type of "Byte" which are is available for selection within the Visual Studio 2005 interface. The following values show in the drop down of data type in VS2005:

    Bigint

    Binary(5)

    Bit

    Char(10)

    DateTime

    Decimal (18,0)

    Float

    Image

    Int

    Money

    NChar(10)

    NText

    Numeric(18,0)

    Nvarchar(50)

    Nvarchar(max)

    Real

    SmallDateTime

    SmallInt

    SmallMoney

    Sql_Variant

    Text

    Timestamp

    TinyInt

    UniqueIdentifier

    Varbinary(50)

    VarBinary(max)

    varchar(10)

    Varchar(max)

    XML

I choose Char with a size of 1. Would this be correct, or am I missing something?

Thanks in advance for your assistance!!

SqlByte maps to tinyint.

No comments:

Post a Comment