i




 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
What does COLLATE Keyword in SQL signify?
02-15-2013, 06:18 AM
Post: #1
What does COLLATE Keyword in SQL signify?
Collation
Quote:Collation defines in the way that the data is sorted. we all know that creating indexes will sort the data in a particular order. There are various collation to sort the data it is normally used when we are storing multilingual data, like if our data is in Hindi then it cannot be sorted in A,B,C,D.... order rite? so there is a collation for Indic languages that defines in which order to sort the data.

Example
Code:
CREATE TABLE [dbo].[sample](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]






View Asad Ali's profile on LinkedIn

Quote




User(s) browsing this thread: 1 Guest(s)