-
char[(n)] - Fixed-length non-Unicode character data with length of n
bytes. n must be a value from 1 through 8,000. Storage size is n bytes.
The SQL-92 synonym for char is character.
nvarchar(n) - Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. The SQL-92 synonyms for nvarchar are national char varying and national character varying.
varchar[(n)] - Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length in bytes of the data entered, not n bytes. The data entered can be 0 characters in length. The SQL-92 synonyms for varchar are char varying or character varying.
marquee
LATEST DOTNET INTERVIEW QUESTIONS
Sunday, 24 November 2013
Difference between char and nvarchar / char and varchar data-type?
Subscribe to:
Post Comments (Atom)
Popular Posts
-
ASP.NET QUESTIONS 1) On which of the operating system below ASP.NET can run? a) Windows XP Professional ...
-
T-SQL Queries 2 tables Employee Phone empid empname salary mgrid empid phnumber Select all employees...
-
76) Select the control which does not have any visible interface a) Datalist b) DropdownList ...
-
1. What is a Web service ? How it is different from remoting? 2. Diiferent life cycle events phases in asp.net web form. 3. OOPS conc...
-
56) Which of the following is true ? a) IsPostBack is a method of System.UI.Web.Page class b) IsPostBa...
-
Interview Questions .NET Windows Forms 1) Write a simple Windows Forms MessageBox statement? 2) Can you write a class witho...
-
126) Which of the following denote ways to manage state in an ASP.Net Application? a) Session objects b)...
-
Asp.net Page Life cycle This is a transcript of a programming manual, to refresh my memory, and it’s always good to RTFM. As a contro...
-
1. What is caching.? 2. Types of cahing? 3. What is cache Block? 4. What are indexers? 5. What is difference between Namespace and assembl...
-
21) To set page title dynamically in ASP.NET which of the following is used ? a) None of the above b) ...
No comments:
Post a Comment