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
- 4921 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
Explain Geography datatype in SQL Server
How do you size a resultset?
What is the use of “join” in sql server?
how many bits ip address consist of? : Sql server database administration
Is there any difference between the primary key and unique key?
What is @@rowcount in sql?
Which table keeps the locking information?
How to rename databases in ms sql server?
How you can get the list of largest tables in a database?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Distinguish between commit and rollback?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How do you handle datasets larger than 50 gb?
Will the writetext statement activate a trigger?
