Results 1 to 17 of 17

What is Collation?

This is a discussion on What is Collation? within the Programming forums, part of the Web Designing & Development category; What is Collation?...

  1. #1
    Member
    Join Date
    Mar 2016
    Posts
    84

    Default What is Collation?

    What is Collation?

  2. #2
    Member
    Join Date
    Mar 2016
    Posts
    68

    Default Re: What is Collation?

    Collation refers to a set of rules that determine how the data is sorted and compared.

  3. #3
    Senior Member
    Join Date
    Feb 2016
    Posts
    159

    Default Re: What is Collation?

    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.

  4. #4
    Senior Member
    Join Date
    Jan 2012
    Posts
    1,964

    Default Re: What is Collation?

    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.

  5. #5
    Senior Member charlottegracie's Avatar
    Join Date
    Jan 2017
    Posts
    207

    Default Re: What is Collation?

    Collation is the assembly of written information into a standard order. Many systems of collation are based on numerical order or alphabetical order, or extensions and combinations thereof. Collation is a fundamental element of most office filing systems, library catalogs, and reference books.

  6. #6
    Senior Member pxljobs's Avatar
    Join Date
    Jul 2016
    Location
    Bangalore
    Posts
    128

    Default Re: What is Collation?

    These refer set of rules that determine how the data is sort and compared..

  7. #7
    Senior Member Ashley234's Avatar
    Join Date
    May 2017
    Posts
    336

    Default Re: What is Collation?

    A collation is the collection and ordering of materials, usually paper. It can be tedious and repetitive work, so most people are more than happy to let a copy machine do the job for them.

  8. #8
    Junior Member
    Join Date
    Jul 2017
    Location
    India
    Posts
    17

    Default Re: What is Collation?

    Collation Controls the way strings values are sorted..the default collation sorts alphabetically using the standard Latin character set..

    The following T-SQL sample illustrates how to set the collation at the column level:

    CREATE TABLE [dbo].[CollationTest](
    [keyColumn] [bigint] NULL,
    [strColumn] [varchar](max) COLLATE Traditional_Spanish_CI_AI NULL
    ) ON [PRIMARY]

  9. #9
    Junior Member byteshubb's Avatar
    Join Date
    Jul 2017
    Location
    india
    Posts
    28

    Default Re: What is Collation?

    Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set.

  10. #10
    Senior Member
    Join Date
    Nov 2016
    Posts
    152

    Default Re: What is Collation?

    Agreed..Thanks.

    Quote Originally Posted by dgsywh View Post
    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.

  11. #11
    Senior Member
    Join Date
    May 2017
    Posts
    477

    Default Re: What is Collation?

    Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set.

  12. #12
    Senior Member
    Join Date
    Nov 2016
    Posts
    152

    Default Re: What is Collation?

    Good one..Keep it going.

    Quote Originally Posted by Sreesri View Post
    Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set.

  13. #13
    Member
    Join Date
    Mar 2018
    Location
    Santa Clara, California, USA
    Posts
    40

    Default Re: What is Collation?

    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.
    Get detailed exposition from here: databasejournal.com/features/mssql/article.php/3302341/SQL-Server-and-Collation.htm

  14. #14
    Junior Member
    Join Date
    Mar 2018
    Posts
    12

    Default Re: What is Collation?

    Hi Shivangi Panwar,

    A collation is a set of rules for comparing and sorting characters.


    Say you have a, and characters. How will you compare them?


    Do a = or a <> ?


    How will you sort them: a, , or , , a etc.


    Collation defines these rules.

    Thanks,
    Emily

  15. #15
    Junior Member
    Join Date
    Mar 2018
    Location
    India
    Posts
    11

    Default Re: What is Collation?

    Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set. Other collations will sort in different orders. For example, a traditional Spanish collation places words beginning with "ch" at the end of a list of words beginning with "c."
    It is not necessary to change the default collation to use non-Latin characters. All shared MS SQL databases support Unicode characters, allowing the storage of a variety of alphabets.

  16. #16
    Member
    Join Date
    Jul 2017
    Posts
    63

    Default Re: What is Collation?

    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.

  17. #17
    Junior Member RSocks's Avatar
    Join Date
    Apr 2018
    Posts
    20

    Default Re: What is Collation?

    sorting and matching databases

Tags for this Thread