{"id":412,"date":"2014-12-18T11:54:56","date_gmt":"2014-12-18T10:54:56","guid":{"rendered":"http:\/\/www.codereview.co\/?p=412"},"modified":"2014-12-18T11:56:54","modified_gmt":"2014-12-18T10:56:54","slug":"sql-server-interview-question-12-what-are-the-different-types-of-collation-sensitivity","status":"publish","type":"post","link":"http:\/\/www.codereview.co\/index.php\/sql-server-tutorials\/sql-server-interview-question-12-what-are-the-different-types-of-collation-sensitivity\/","title":{"rendered":"Sql Server Interview Question #12 :What are the different types of Collation Sensitivity?"},"content":{"rendered":"

Sql Server Interview Question:<\/strong><\/p>\n

What are the different types of Collation Sensitivity?<\/p>\n

Answer<\/strong><\/p>\n

    \n
  1. Case sensitivity<\/strong> – A and a, B and b, etc.<\/li>\n
  2. Accent sensitivity<\/strong><\/li>\n
  3. Kana Sensitivity<\/strong> – When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana sensitive.<\/li>\n
  4. Width sensitivity<\/strong> – A single-byte character (half-width) and the same character represented as a double-byte character (full-width) are treated differently than it is width sensitive.<\/li>\n<\/ol>\n

     <\/p>\n

    Thanks for reading this article,<\/strong><\/p>\n

    Next steps :<\/strong><\/p>\n

      \n
    1. Share this with your colleagues because Sharing is Learning<\/strong><\/li>\n
    2. Comment below if you need any assistance<\/strong><\/li>\n<\/ol>\n

      Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

      Sql Server Interview Question: What are the different types of Collation Sensitivity?<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[172,3],"tags":[158,199,159,13,12],"_links":{"self":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/412"}],"collection":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/comments?post=412"}],"version-history":[{"count":6,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/412\/revisions"}],"predecessor-version":[{"id":460,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/412\/revisions\/460"}],"wp:attachment":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/media?parent=412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/categories?post=412"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/tags?post=412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}