What Are the Constraints on Character Sets?

When creating a database, you can specify a character set using WITH ENCODING. For details about the supported character sets, see the official documentation.

Constraints

When template1 is used to create a database, the character set defined for this template cannot be changed. Otherwise, an error is reported. For details, see TEMPLATE Option.

Example

CREATE DATABASE my_db WITH ENCODING 'UTF8';

Parent Topic: FAQ

Previous topic: How Do I Create a Database Using a Command-Line Interface (CLI)?

Next topic: Performing Basic Operations Using pgAdmin

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot