本文探讨了基于名称判断语言排序规则的方法，并解释了单语种排序（如GERMAN）与多语种排序（如FRENCH_M）的区别。单语种排序通常前缀长度为1000字符，而多语种排序前缀长度一般为500字符。
466.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.
Answer: A
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions113.htm#SQLRF51562
1是monolingual collations。
2应该是multilingual collations。
For monolingual collations, for example FRENCH, the prefix length is typically 1000 characters. For multilingual collations, for example GENERIC_M, the prefix is typically 500 characters. The exact length may be lower or higher depending on the collation and the characters contained in char.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
