adspace


What are all different types of collation sensitivity?

Answer Posted / Soni Kumari

"In SQL, there are three levels of collation sensitivity: Case sensitive (uppercase and lowercase characters are treated as distinct), Case insensitive (uppercase and lowercase characters are treated as the same), and Accent sensitive (accented and non-accented characters are treated as distinct)"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current version of sql?

1106


how to use regular expression in pattern match conditions? : Sql dba

1125


what are aggregate and scalar functions? : Sql dba

1142


Is inner join faster than left join?

1287


Do we need to rebuild index after truncate?

1154


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what is sql server agent? : Sql dba

1189


define sql insert statement ? : Sql dba

1110


how many tables will create when we create table, what are they? : Sql dba

1156


what is dbms? : Sql dba

1070


Can we rollback truncate?

1083


What is the current version of postgresql?

1188


what is bcp? When does it used? : Sql dba

1065


What is your daily office routine?

2353


what are all the common sql function? : Sql dba

1141