Skip to main content

database_character_sets

Creates, updates, deletes, gets or lists a database_character_sets resource.

Overview​

Namedatabase_character_sets
TypeResource
Idgoogle.oracledatabase.database_character_sets

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringIdentifier. The name of the Database Character Set resource in the following format: projects/{project}/locations/{region}/databaseCharacterSets/{database_character_set}
characterSetstringOutput only. The character set name for the Database which is the ID in the resource name.
characterSetTypestringOutput only. The character set type for the Database. (CHARACTER_SET_TYPE_UNSPECIFIED, DATABASE, NATIONAL)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsIdfilter, pageSize, pageTokenList DatabaseCharacterSets for the given project and location.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
locationsIdstring
projectsIdstring
filterstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples​

List DatabaseCharacterSets for the given project and location.

SELECT
name,
characterSet,
characterSetType
FROM google.oracledatabase.database_character_sets
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;