what are different types of collation sensitivity? : Sql dba



what are different types of collation sensitivity? : Sql dba..

Answer / Varunesh Pandey

Collation sensitivity refers to the way a database sorts characters or strings. In SQL DBA, there are three main types: case-sensitive, case-insensitive, and accent-sensitive. Case-sensitive compares the exact text, ignoring any differences in uppercase or lowercase letters. Case-insensitive ignores the difference between uppercase and lowercase letters when comparing text. Accent-sensitive considers diacritics (such as accents) when comparing text.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,


What are Anti joins

1 Answers   IBM,


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1 Answers  


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1 Answers  


how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1 Answers  


What is synchronized subquery?

1 Answers  


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1 Answers  


What is example of database?

1 Answers  


Is sql procedural language?

1 Answers  


What is sql trigger example?

1 Answers  


How the execution will be done in exceptions?

2 Answers  


Categories