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

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  


How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  


Explain a differential backup?

0 Answers  


ow to bring suspect mode datbase online from scratch

0 Answers  


What is snapshot replication?

0 Answers  






Can you leave a union at any time?

0 Answers  


two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,


write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,


sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  


how many type of subquery?

2 Answers  


Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,


How can you control the amount of free space in your index pages?

0 Answers  


Categories