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
What is SQL Server?
How to make remote connection in database?
What is data set in report?
What are the different types of locks in the database?
How to include date and time values in sql statements?
Do you know the capabilities of cursors?
Does windows server 2016 come with sql server?
What is the datatype of rowid?
What is model database in sql server?
What is a full text index?
Can you leave a union at any time?
What are the requirements on sql server network connections?
Can we write ddl in trigger?
Are all views updatable ?
Can the query output be sorted by multiple columns in ms sql server?