A script-enabled browser is required for this page to function properly.

ORA_NLS.Linguistic_Collate

Description

Returns TRUE or FALSE, depending on whether the characters in the current character set need to be collated according to special linguistic information.

Syntax


FUNCTION Ora_Nls.Linguistic_Collate
RETURN BOOLEAN;

Returns

TRUE or FALSE.

Usage Notes

If this function returns TRUE, a binary sort of two characters will not necessarily return the correct value. This is because encoding schemes for character sets do not necessarily define all characters in ascending numerical order.

In addition, the sort position of a character may vary for different languages. For example, an "ä" is sorted before "b" in German, but after "z" in Swedish.

Example


 /*
** Determine whether or not special collating is
** needed.
*/
collate := Ora_Nls.Linguistic_Collate;
  IF collate = TRUE THEN
    lang_name (langinfo.txt);
    Text_IO.Put ('This needs special collating.');
  ENDIF;