ORA_NLS.LINGUISTIC_COLLATE
built-in functionThis function 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;
TRUE
or FALSE
.
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;
About the ORA_NLS
built-in package
Copyright © 1984, 2005, Oracle. All rights reserved.