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
- 4951 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
What are user-defined functions (udfs) in sql server?
What are the differences between local and global temporary tables?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Do you know what are pages and extents? : SQL Server Architecture
Why do we backup Active Directory ?
How to use subqueries with the exists operators in ms sql server?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are key constraints?
How will you monitor replication latency in transactional replication? : sql server replication
What are the differences between left join and inner join in sql server?
what are the reporting service components in SSRS?
how many type of indexing in database?
If the job running very slow what is the action you do
What does top operator do?
How to list all schemas in a database?
