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.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsIdpageSize, pageToken, filterList 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 pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
;