What is collation sensitivity? Explain different types.Ask Questions

 Posted on 08/03/2018

                                                                                                                 
Share On: facebook gplus twitter
profile
Asked by Hardik Parekh on 08/03/2018 Score: 234 points
Add Comment:

Comments

1 Answers

0 Corrected Answers
Aproved Answers
0
Profile
Answered by hardik chaudhary on 8/13/2018 1:12:57 PM Score: 432 points

Collection is: 

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

the collation sensitivity are four type see bellow:

1. Case  sensitivity  

If A anaB and b, etc.. are treated in the same way then it is case-insensitive. A computer treats A  and a diffidently because it uses ASCII code to differentiate the input. The ASCII value of A is 65, while a is 97. The ASCII value of B is 66 and b is 98.

2. Accent sensitivity

If a and áo and ó are treated in the same way, then it is accent-insensitive. A computer treats a and á differently because it uses ASCII code for differentiating the input. The ASCII value of a is 97 and á is 225. The ASCII value of o is 111 and ó is 243.

3.Kana Sensitivity

When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana sensitive.

4.Width sensitivity

When a single-byte character (half-width) and the same character when represented as a double-byte character (full-width) are treated differently then it is width sensitive. 

 


Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.