Home

Company

Products
       DNN KickStart
          DNN KickStart Manual
             Installation
             Getting Started
             Load module
             Save module
             Module meta data
                Company
                Module name
                Version
                Description
                Scope
             Fields
                Field types
                   Lookup
                Sequence
             Generate module
                Options
                   output folder
                   zip file
                   project folder
                Export package
                Generate code
                Export to DNN Web
                Export as WebProject
             Module controls
                asp:datagrid Control
             Module output
             Tips and Tricks
                Field wizard
                Telerik radGrid
                Screen tips
                Help and validation text
                Lookup fields
             Functions
                Searchable
          Inside
          DNN KickStart Release info
          Screen Shots
          FAQ
          DNN KickStart Case
             Case source code
          Sample modules
             DNS Root Servers sample
       DNN Mass Mail
          DNN Mass Mail Screenshots

Contact

Forum

Downloads

Knowledge base
       SAP XI Links
       Website tools
       Web 2.0
       SAP
       VB.NET
          How to
             Create method description
          ComponentOne
          WinForm Controls
          Working with data
          Networks and .Net remoting
       MSSQL Server
          Data type
          MS SQL Field Lengths
          Reserved words
          SQL Server 2005
       ASP.NET
          ObjectDataSource
          Viewstate
       Webservices
       Regular Expressions
       DNN KickStart Tips and Tricks
       Java
       DotNetNuke
          Tools
          Documents
          Architecture
             Core Services
                Membership
             DotNetNuke Namespaces
             Portal Structures and Methods
             Module Settings
             Common Functions
             Users, Roles, and Security
             Exceptions and Logging
             Localization
             Core Controls
             Module Controls
             Module installation
             Navigation
             Module Architecture
          Ajax / Atlas
             Pre DotNetNuke 4.5.x Ajax /Atlas
          Links
          DotNetNuke search
          DotNetNuke Module files
          Development
             Introduction
          Installation guide
             SQLExpress Setup database
          Web Projects
Tuesday, February 07, 2012  
You are here:  Knowledge base * MSSQL Server * MS SQL Field Lengths Register  Login
MS SQL Server field lengths

Here tou can find which length is used for a MS SQL Field

 

Data type Default length (characters)
Char Length defined for the column
Varchar Length defined for the column
Nchar Twice the length defined for the column
Nvarchar Twice the length defined for the column
Text 0
Ntext 0
Bit 1
Binary Twice the length defined for the column + 1
Varbinary Twice the length defined for the column + 1
Image 0
Datetime 24
Smalldatetime 24
Float 30
Real 30
Int 12
Bigint 19
Smallint 7
Tinyint 5
Money 30
Smallmoney 30
Decimal 41*
Numeric 41*
Uniqueidentifier 37
Timestamp 17

See also:
Microsoft Knowledge Base

 

 
Home  |  Company  |  Products  |  Contact  |  Forum  |  Downloads  |  Knowledge base
Copyright (c) 2012 FRENT IT   |  Privacy Statement  |  Terms Of Use