- When installing Control-M/Enterprise Manager and Control-M/Server, "Enable Chinese, Japanese, Korean Support" (CJK) check-box is available to be selected as below:
- If the "Enable Chinese, Japanese, Korean Support" (CJK) check-box is selected, the default PostgreSQL Client that is installed on the Control-M/Enterprise Manager and Control-M/Server will have a UTF8 encoding.
Do ensure PostgreSQL server encoding as UTF-8 and the template_utf Database with UTF8 encoding is present in the existing PostgreSQL Database Server.
- If the "Enable Chinese, Japanese, Korean Support" (CJK) check-box is not selected, the default PostgreSQL Client that is installed on the Control-M/Enterprise Manager and Control-M/Server will have a LATIN1 encoding.
Do ensure PostgreSQL server encoding as LATIN1 and the template1 Database with LATIN1 encoding is present in your existing PostgreSQL server.
- Below table shows the details of encoding required:
|
|
PostgreSQL Client encoding
|
PostgreSQL server encoding
|
Templates required in PostgreSQL server
|
|
CJK not enabled in Control-M
|
Latin1
|
Latin1
|
template1 With Latin1 encoding
|
|
CJK enabled in Control-M
|
UTF-8
|
UTF-8
|
template_utf With UTF-8 encoding
|
Additional Information:
- To confirm the databases availability and its encoding in existing PostgreSQL server, please connect to database server and run \l command.
For example, below PostgreSQL server is configured with LATIN1, and the template1 is in LATIN1 too, this server can be used for Control-M installation without CJK enabled.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------------+----------+----------+---------+-------+-----------------------
postgres | postgres | LATIN1 | C | C |
template0 | postgres | LATIN1 | C | C | =c/postgres + postgres=CTc/postgres
template1 | postgres | LATIN1 | C | C | =c/postgres + postgres=CTc/postgres
template_utf | postgres | UTF8 | C | C |
(4 rows)
Below PostgreSQL server is configured with UTF8, and the template_utf is in UTF8 too, this server can be used for Control-M installation with CJK enabled.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------------+----------+----------+---------+-------+-----------------------
postgres | postgres | UTF8 | C | C |
template0 | postgres | LATIN1 | C | C | =c/postgres + postgres=CTc/postgres
template1 | postgres | LATIN1 | C | C | =c/postgres + postgres=CTc/postgres
template_utf | postgres | UTF8 | C | C |
(4 rows)