# 22. Virtuoso Functions Guide - charsets_list

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
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()