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

ORA_NLS.LINGUISTIC_SPECIALS built-in function

This function returns true or false, depending on whether there are linguistic specials in use.

Syntax


FUNCTION ORA_NLS.LINGUISTIC_SPECIALS
RETURN BOOLEAN;

Returns

TRUE or FALSE.

Usage notes

Linguistic specials are language-specific special cases for collation and case conversion (upper and lower). An example The uppercase for the German sharp "s" (one byte), which is "SS" (two bytes). Sorting Also done according to the two-byte value.

Linguistic specials are defined in a linguistic definition along with normal collation. When there are linguistic specials defined for the linguistic definition that is in effect for a specific language handle, output sizes of functions handling linguistic specials can be larger than input string sizes.

Example


/*
** Determine whether or not specials are in use
** and how to deal with them if so
*/
specials := ORA_NLS.LINGUISTIC_SPECIALS;
 IF specials = TRUE THEN
  lang_name (langinfo.txt);
  TEXT_IO.PUT ('Specials are in use.');
ENDIF;

See also

About the ORA_NLS built-in package

ORA_NLS built-in package