What is the default value of CHAR type?

Answers were Sorted based on User's Feedback



What is the default value of CHAR type?..

Answer / bijoy vp

'\u0000'

Is This Answer Correct ?    34 Yes 6 No

What is the default value of CHAR type?..

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

What is the default value of CHAR type?..

Answer / venky

Blank Space

Is This Answer Correct ?    2 Yes 0 No

What is the default value of CHAR type?..

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

What is the default value of CHAR type?..

Answer / foolishchild

'c'. where c represent any character.

Is This Answer Correct ?    1 Yes 0 No

What is the default value of CHAR type?..

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 the default value of CHAR type?..

Answer / satish

8

Is This Answer Correct ?    2 Yes 7 No

What is the default value of CHAR type?..

Answer / asha

Null

Is This Answer Correct ?    8 Yes 15 No

What is the default value of CHAR type?..

Answer / chiru

1

Is This Answer Correct ?    3 Yes 13 No

What is the default value of CHAR type?..

Answer / sujitha

1

Is This Answer Correct ?    7 Yes 27 No

Post New Answer

More SQL Server Interview Questions

How to display a past time in days, hours and minutes?

0 Answers  


What does COMMIT command do?

0 Answers   Amdocs,


Where sql server usernames and passwords are stored in a sql server?

0 Answers  


What is the recovery model? List the types of recovery model available in sql server?

0 Answers  


What is correlated subquery in sql server?

0 Answers  






Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,


What happens if time-only values are provided as date and time literals?

0 Answers  


What are logical database components? : SQL Server Architecture

0 Answers  


select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,


What options are available to audit login activity? : sql server security

0 Answers  


how to avoid cursors? : Sql server database administration

0 Answers  


what is a self join? Explain it with an example? : Sql server database administration

0 Answers  


Categories