{"id":308,"date":"2014-10-15T17:30:52","date_gmt":"2014-10-15T16:30:52","guid":{"rendered":"http:\/\/www.codereview.co\/?p=308"},"modified":"2014-10-15T14:51:17","modified_gmt":"2014-10-15T13:51:17","slug":"sql-interview-question-3-what-are-different-types-of-collation-sensitivity","status":"publish","type":"post","link":"http:\/\/www.codereview.co\/index.php\/sql-server-tutorials\/sql-interview-question-3-what-are-different-types-of-collation-sensitivity\/","title":{"rendered":"Sql Interview Question #3: What are different types of collation sensitivity?"},"content":{"rendered":"<p><span style=\"color: #000000;\"><strong>Sql Interview Question<\/strong><\/span><\/p>\n<p>What are different types of collation sensitivity?<\/p>\n<p><span style=\"color: #000000;\"><strong>Solution<\/strong><\/span><!--more--><\/p>\n<p><span style=\"color: #000000;\"><em>Case sensitivity <\/em>&#8211; A and a, B and b, etc.<\/span><\/p>\n<p><span style=\"color: #000000;\"><em>Accent sensitiv<\/em>ity &#8211; a and \u00e1, o and \u00f3, etc.<\/span><\/p>\n<p><span style=\"color: #000000;\"><em>Kana Sensitivity <\/em>&#8211; When Japanese Kana, Hiragana, and Katakana characters are treated differently, it is called Kana sensitive.<\/span><\/p>\n<p><span style=\"color: #000000;\"><em>Width sensitivity <\/em>\u2013 When a single-byte character (half-width) and the same character represented as a double-byte character (full-width) are treated differently, it is width sensitive.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>Thanks for reading this article,<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Next steps :<\/strong><\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><strong>Share this with your colleagues because Sharing is Learning<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>Comment below if you need any assistance<\/strong><\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Sql Interview Question What are different types of collation sensitivity? Solution<\/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":[160,158,161,162,159,163],"_links":{"self":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/308"}],"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=308"}],"version-history":[{"count":3,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/308\/revisions"}],"predecessor-version":[{"id":361,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/308\/revisions\/361"}],"wp:attachment":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/media?parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/categories?post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/tags?post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}