Name

charsets_list — List known character set names and aliases.

Synopsis

any charsets_list ( in gen_res_set integer );

Description

This function produces a list of all character set names and aliases known to Virtuoso. The returned value is an array of string s 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.

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.

Errors

This function can generate the following errors: SR008 SR001

Examples

Example24.39.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.


Example24.40.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'
....