053-469

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?
A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default.

  The _AI suffix implies that an accent-insensitive sort will be performed.Accent-insensitive sorts are also case insensitive by default.The _CI suffix implies that a case-insensitive sort will be performed,but it will not be accent insensitive.Specifying both suffixes(_AI_CI) is illegal.

posted @ 2017-11-15 10:31  巴啦啦大魔王  阅读(162)  评论(0编辑  收藏  举报