What can you determine about the following linguistic sorts based only on their names?

What can you determine about the following linguistic sorts based only on their names?
1. GERMAN
2. FRENCH_M

What can you determine about the following linguistic sorts based only on their names?
1. GERMAN
2. FRENCH_M

A.
1 is a monolingual sort.

B.
2 is a monolingual sort.

C.
1 is case insensitive.

D.
Both 1 and 2 are case insensitive.

E.
Case sensitivity is unknown.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jake from SF

Jake from SF

A is correct:

https://docs.oracle.com/cd/B28359_01/server.111/b28298/ch5lingsort.htm

For #2: For example, Oracle Database supports a monolingual French sort (FRENCH), but you can specify a multilingual French sort (FRENCH_M). _M represents the ISO 14651 standard for multilingual sorting. The sorting order is based on the GENERIC_M sorting order and can sort diacritical marks from right to left. Oracle recommends using a multilingual linguistic sort if the tables contain multilingual data. If the tables contain only French, then a monolingual French sort may have better performance because it uses less memory. It uses less memory because fewer characters are defined in a monolingual French sort than in a multilingual French sort. There is a tradeoff between the scope and the performance of a sort.