Dbtype + sqldbtype + System Data Type table

Source: Internet
Author: User
SQL type

Dbtype

Sqldbtype

Type

Bit

Boolean

Bit

System. Boolean

Tinyint

Byte

Tinyint

System. byte

Smallint

Int16

Smallint

System. int16

Int

Int32

Int

System. int32

Bigint

Int64

Bigint

System. int64

Real

Single

Real

System. Single

Float

Double

Float

System. Double

Smallmoney

Decimal

Smallmoney

System. Decimal

Money

Decimal

Money

System. Decimal

Numeric

Decimal

Decimal

System. Decimal

Decimal

Decimal

Decimal

System. Decimal

Smalldatetime

Datetime

Smalldatetime

System. datetime

Datetime

Datetime

Datetime

System. datetime

Binary

Byte []

Binary

Array of system. byte

Varbinary

Byte []

Varbinary

Array of system. byte

Image

Byte []

Image

Array of system. byte

Timestamp

Byte []

Timestamp

Array of system. byte

Char

String

Char

System. String

Nchar

String

Nchar

System. String

Varchar

String

Varchar

System. String

Nvarchar

String

Nvarchar

System. String

Text

String

Text

System. String

Ntext

String

Ntext

System. String

XML

String

XML

System. String

Uniqueidentifier

Guid

Uniqueidentifier

System. guid

SQL _variant

Object

Variant

System. Object

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.