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 database files are there in sql server 2000?what are they?
How to download and install the scaled-down database adventureworkslt?
What is the difference between for xml raw and for xml auto?
How will you hide an attribute? : sql server analysis services, ssas
Differentiate between ms sql server reporting services vs crystal reports?
What is postgresql server?
Do you know what is xpath?
What is the osql utility?
What are the basic functions for master, msdb, model, tempdb databases?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
what are acid properties? : Sql server database administration
How do we return a record set from a Stored Procedure in SQl server 2000?
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)