Name

collation_define — define a new collation

Synopsis

collation_define ( in COLLATION_NAME varchar ,
in FILE_PATH varchar ,
in ADD_TYPE integer );

Description

This function lets you define a new collation.

Parameters

COLLATION_NAME

The name to be assigned to the new collation.

FILE_PATH

The path and file name of the collation definition file. The path must be specified in the format appropriate to the operating system hosting the Virtuoso server.

ADD_TYPE

is the type of the new collation: 1 for 8-bit collation (256-byte blob); 2 for UNICODE collation (65536-byte Unicode blob). A value of 0 instructs the function only to check the validity of the definition file and to return a resultset containing the codes of the valid exception definitions.

Return Types

If 0 is supplied to the ADD_TYPE parameter then a result set will be returned containing the codes of the valid definitions.