Collation sequence in sql server

It is containing all topics related to Visual Basic, .NET Framework, Web Resource, GDI etc.
Ladva Nidhi
Posts: 295
Joined: Sat Sep 20, 2014 5:26 pm
Contact:

Collation sequence in sql server

Postby Ladva Nidhi » Mon Nov 10, 2014 3:14 am

Can you explain collation sequence in sql server?


sonall gajera

Re: Collation sequence in sql server

Postby sonall gajera » Fri Jul 03, 2015 5:05 pm

Microsoft SQL Server 2000 supports several collations. A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General (the Latin alphabet used by western European languages).

jeff2345
Posts: 49
Joined: Tue May 05, 2015 7:09 pm
Contact:

Re: Collation sequence in sql server

Postby jeff2345 » Wed Oct 07, 2015 11:33 am

SQL Server Collation Fundamentals:

Microsoft® SQL Server™ 2000 supports several collations. A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General.

Each SQL Server collation specifies three properties:

1]The sort order to use for Unicode data types (nchar, nvarchar, and ntext). A sort order defines the sequence in which characters are sorted, and the way characters are evaluated in comparison operations.

2]The sort order to use for non-Unicode character data types (char, varchar, and text).

3]The code page used to store non-Unicode character data.

SQL Server 2000 collations can be specified at many levels. When you install an instance of SQL Server 2000, you specify the default collation for that instance. Each time you create a database, you can specify the default collation used for the database. If you do not specify a collation, the default collation for the database is the default collation for the instance. Whenever you define a character column, you can specify its collation. If you do not specify a collation, the column is created with the default collation of the database. You cannot specify a collation for character variables and parameters; they are always created with the default collation of the database.



Return to “Visual Basic .NET and ASP.NET”

Who is online

Users browsing this forum: No registered users and 3 guests