You can specify the default server character set:
- For a user, using the DEFAULT CHARACTER SET options in a CREATE USER or MODIFY USER statement.
- For the data stored in a specific table column, using the CHARACTER SET option in a CREATE TABLE or ALTER TABLE statement.
If no CHARACTER SET option is used for a CHARACTER column being defined in a CREATE TABLE or ALTER TABLE statement, the character set for the column is determined by the user default, if specified, or by the system default (LATIN in VantageCloud Lake).