What do you mean by COLLATION?

Answers were Sorted based on User's Feedback



What do you mean by COLLATION?..

Answer / koti ,khammam

collation is a set of rules to determine how data is
sorted and compared.

Is This Answer Correct ?    10 Yes 0 No

What do you mean by COLLATION?..

Answer / guest

Collation is basically the sort order. There are three types
of sort order Dictionary case sensitive, Dictonary - case
insensitive and Binary.

Is This Answer Correct ?    8 Yes 2 No

What do you mean by COLLATION?..

Answer / hari

collation is a set of rules determine the how data is
sorted and compared.

Case sensitity collation
Accent Sensitity collation
Kane sensitiy collation

Is This Answer Correct ?    5 Yes 1 No

What do you mean by COLLATION?..

Answer / dinesh sharma

Collation refers to a set of rules that determine how data
is sorted and compared. Character data is sorted using
rules that define the correct character sequence, with
options for specifying case-sensitivity, accent marks, kana
character types and character width.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to modify an existing stored procedure in ms sql server?

0 Answers  


Do you know sql server 2008 backup compression?

0 Answers  


sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  


employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  


What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,






Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  


Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  


CREATE a table from another table

2 Answers  


Can we drop user if user mapped to any logins

1 Answers  


What is unique key constraint?

0 Answers  


can you any body tell me which service pack is installed in the sql server?

3 Answers  


How to set database to be read_only in ms sql server?

0 Answers  


Categories