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 explicit cursors?
What about UPDATESTATISTICS ?
What is a mutating table error and how can you get around it?
Explain what are the different index configurations a table can have?
What is an indexing strategy?
How can u get the number of pupils connecting the database?
How to list all schemas in a database?
What protocol does sql server use?
What are the transaction properties?
Write a query for primary key constraint with identity key word?
Define inner join in sql server joins?
Who is the owner of a schema in ms sql server?