What is the default value of CHAR type?
Answers were Sorted based on User's Feedback
Answer / yash
The default value of a variable of value type is the value
assigned in the default constructor. For simple types this
value corresponds to a bit pattern of all zeros:
• For integer types, the default value is 0
• For char, the default value is `\u0000' //Unicode
• For float, the default value is 0.0f
• For double, the default value is 0.0d
• For decimal, the default value is 0.0m
• For bool, the default value is false
| Is This Answer Correct ? | 26 Yes | 2 No |
Answer / mallesh
In Sybase the default value for Char is NULL
you can check it as
declare @val char(5)
select @val
o/p is NULL
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / samrat sen
In Sql Server 2000 the default value for char datatype is 10
| Is This Answer Correct ? | 5 Yes | 6 No |
How many types of system privileges are there, Can we add or delete privileges?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Explain concepts of analysis services?
What is a DBMS, query, SQL?
what is the purpose of creating view is sql server 2000
event classes in sql server
in how many ways we can use count()
what is nonclustered index
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
What is an expression in ms sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is temporary stored procedure?
Oracle (3253)
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)