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
- 4851 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / penchal das
Char is static in size where as Varchar is dynamic in size.
if we use char(15) and we have used only 10 charectes then remaining memory space will be wasted.
In case of Varchar(15) if use 10 chars remaining memory space will be freed.
| Is This Answer Correct ? | 1 Yes | 0 No |
What stored by the model? : sql server database administration
Do you know what is a with(nolock)?
What do you understand by a view? What does the with check option clause for a view do?
What is the maximum number of index per table?
Explain what are sparse columns?
What is dknf in normalization form?
How do I clean up sql server transaction log?
What is an example of a primary key?
What is the sql server agent?
What is a partitioned view?
How to insert multiple rows with one insert statement in ms sql server?
where the connection string store in the database
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
