From the objective of OSS-DB Exam Silver
- General Knowledge - general features of OSS-DB
Sample Question
2.09
Choose two statements that are correct about the character sets (encoding method) supported by PostgreSQL.
- When the server and client are on the same machine, you need to use the same character set
- Japanese shift JIS is supported as a server character set
- Japanese shift JIS as a client character set is supported
- You can use a different character set for each database in the database cluster
- You can use a different character set for each table in the database
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/01
Answer and Explanation
In many RDBMSs including PostgreSQL, different character sets (encoding, encoding method) can be defined between the server and the client, and the database server appropriately converts the character code according to the character set desired by the client.
The types of character sets supported by PostgreSQL are described in the manual, but the character sets available on the server and the character set available on the client are different, and some character sets (even though they can be used on the client) can not be used on the server.
There are EUC, shift JIS, UTF 8 in the character set commonly used in Japanese. EUC and UTF 8 can be used by either server or client, but shift JIS can only be used by clients.
The default character set used in the database cluster is specified with the option of the initdb command, but the character set used in each database in the cluster can be specified with the option of the createdb command or the CREATE DATABASE statement, it does not have to be the same as the cluster's default character set.
The character set used in each table in the database is the character set of the database and can not be changed for each table.
Therefore, the correct answers are C and D