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
Example 24.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.
Example 24.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' ....