DIRECTORY_DATASTORE Attributes

DIRECTORY_DATASTORE has the following attributes:

Table 5 DIRECTORY_DATASTORE Attributes

Attribute Attribute Values
directory

Specify the name of the directory object where the data to be indexed is stored. The default is NULL.

If you have access to the Oracle directory object, then you can also access the files in its sub-directories.

filename_charset

Specify a valid Oracle character set name (maximum length 30 characters) to be used by the directory datastore for converting file names.

In general, the Oracle Database can use a different character set than the operating system. This can lead to problems in finding files (which may raise DRG-11513 errors) when the indexed column contains characters that are not convertible to the operating system character set. By default, the directory datastore will convert the file name to WE8ISO8859p1 for ASCII platforms or WE8EBCDIC1047 for EBCDIC platforms.

However, this may not be sufficient for applications with multibyte character sets for both the database and the operating system, because neither WE8ISO8859p1 nor WE8EBCDIC1047 supports multibyte characters. The attribute filename_charset rectifies this problem. If specified, then the datastore will convert from the database character set to the specified character set rather than to ISO8859 or EBCDIC.

If the filename_charset attribute is the same as the database character set, then the file name is used as is. If filename_charset is not a valid character set, then the error "DRG-10763: value %s is not a valid character set" is raised.