Home Forums SQL Server 2014 Development - SQL Server 2014 Is COLLATE able to sort for line break characters? RE: Is COLLATE able to sort for line break characters?

  • May 18, 2016 at 1:32 pm

    #1880014

    There are four options associated with (non-binary) collations

  • case sensitivity
  • accent sensitivity
  • kana sensitivity
  • width sensitivity

    • To the best of my knowledge, carriage return and line feed do not have alternate representations that differ on any of these options, so they will be unaffected by changes in the collation.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA