# 22. Virtuoso Functions Guide - collation_define

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
__any_grants
close
collation_define
complete_table_name
delay
end_result
exec
exec_next
exec_result
exec_result_names
identity_value
name_part
registry_get
registry_get_all
registry_name_is_pro...
registry_remove
registry_set
result
result_names
row_count
sequence_get_all
sequence_next
sequence_remove
sequence_set
set_identity_column
set_row_count
set_user_id
signal
sinv_create_inverse
sinv_create_key_mapp...
sinv_drop_inverse
sys_stat_analyze
sys_stat_histogram
table_drop_policy
table_set_policy
username
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## collation_define

define a new collation
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.