what is the basic diffrence betn a col declared in char(1)
and in varchar(1)
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
Why do we use stored procedures in sql server?
Write a code to select distinct records without using the DISTINCT keyword.
What is Extended user-defined?
What is the ‘fillfactor’?
How do I find query history in sql server?
What is the process of normalization?
How to view existing indexes on an given table using sp_help?
What is abstracting periodical?
How to create a simple user defined function in ms sql server?
How do I uninstall sql server 2014?
What is the difference between char and varchar2 datatype in sql?
Explain sql server service broker?
What is the usage of sign function?
How you can change a cross join into an inner join?
How to generate create table script on an existing table in ms sql server?