Interested to Buy Any Domain ? << Click Here >> for more details...
what is the basic diffrence betn a col declared in char(1)
and in varchar(1)
- 2 Answers
- 4964 Views
- I also Faced
- E-Mail Answers
Answer Posted / nilam gandhi
char(1) is a fixed length character data,size character long.
Maximum size 2000 bytes.
Default size is 1 byte.
Varchar(1) is a variable length character string.
And the maximum size of the varchar(1) data type is 4000 bytes.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many types of functions are there in sql server?
What are the disadvantages of using the stored procedures?
Describe the functionalities that views support.
How to define and use table alias names in ms sql server?
What is ms sql server triggers?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How to create a stored procedure with a statement block in ms sql server?
What are transactions in sql?
Why do we use non clustered index?
What are three major types of constraints?
What are the basic functions for master, msdb, model, tempdb databases?
What are click through reports?
What is pessimistic concurrency?
What is the name of reporting services config file and what’s it’s used for?
How to convert numeric expression data types using the cast() function?
