Returns TRUE or FALSE, depending on whether the characters in the current character set need to be collated according to special linguistic information.
FUNCTION Ora_Nls.Linguistic_Collate
RETURN BOOLEAN;
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.
/*
** 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;