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 |
What is similarity and difference between truncate and delete in sql?
What happens if you add a new index to large table?
What are the different acid properties?
Can we insert data into view sql server?
What is a subquery in a select query statement in ms sql server?
Explain sql server service broker?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
explain different types of constraints? : Sql server database administration
How to get the number of affected rows?
What is resource db in sql server?
Can we use where and having clause together?
What should be the fill factor for indexes created on tables? : sql server database administration
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)