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
charset_define
charset_recode
charsets_list
current_charset
elh_get_handler
elh_load_handler
lh_get_handler
lh_load_handler
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
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

charsets_list

List known character set names and aliases.
any charsets_list (in gen_res_set integer);
Parameters
gen_res_set – Integer flag to determine whether to produce a result set: 0 means no, 1 means yes.
Return Types

An array of string, optionally generates a result set of single varchar columns.

Description

This function produces a list of all character set names and aliases known to Virtuoso. The returned value is an array of strings with a character set name as each element. If the gen_res_set flag is 1, the function also produces a result set in which each row contains one varchar column with a name of a character set or alias.

Errors

This function can generate the following errors:

SR001.SR008,

Examples
List character sets as a result set
SQL> charsets_list(1);
CS_NAME
VARCHAR
___________________________________________

437
819
850
855
866
874
999
CP1250
CP1251
CP1252
CP1257
CP437
....

There are 132 predefined character sets in total that would be listed.

Get first 2 character set names/aliases
....
x:= charsets_list (0);
y := aref (x, 0); -- will be '437'
y := aref (x, 1); -- will be '819'
....
See Also

charset_define()