Collation specifies three properties:
- Sort order to use for Unicode data types ( nchar , nvarchar and ntext )
- Sort order to use for non-Unicode data types ( char , varchar and text )
- Code page to store non-Unicode character data
What is Collations in SQL Server ?
Collations control physical storage of characters strings in SQL Server. Collation specifies bit patterns that represent each character and the rules by which characters are sorted and compared.
Collation specifies three properties:
Collation specifies three properties:
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Answer : WCF belongs to System.ServiceModel
-
Different types of assemblies are : Static and Dynamic assemblies Private and Shared assemblies Single file and Multiple file assemblies ...
-
Authorization is used to determine whether user has access to resource or not. There are two ways to authorize a resource : File authoriza...
-
Operation behaviour are scoped at Operation level. It is used for transaction flow , serialization , parameter handling.
-
Different type of method parameters in C# are : Value Parameter Reference Parameter Output Parameter
-
Abstract class has following features : cannot be instantiated contain abstact methods and properties cannot modify abstract class with s...
-
OOPs concepts that C# supports are : Abstraction : is a process that involves identifying the crucial behavior of an object and eliminatin...
-
Characteristics of well designed normalized database are : Table should have identifier Table should store data for single type of entity...
-
There are five types of contracts : Service Contract Operation Contract Data Contract Message Contract Fault Contract Please refer be...
Posts
No comments:
Post a Comment