Help Center> Relational Database Service> Best Practices> RDS for PostgreSQL> Creating Databases> FAQ> What Do I Do If the Character Set Does Not Match the Locale During Database Creation?

Updated on 2022-11-02 GMT+08:00

View PDF

What Do I Do If the Character Set Does Not Match the Locale During Database Creation?

If the LC_COLLATE you specified does not match the character set during database creation, the following error message is displayed:

CREATE DATABASE my_db2 WITH LC_COLLATE ='zh_SG' LC_CTYPE ='zh_SG' ;

Solution:

Query the character set supported by the template database. For details, see How Do I View the Created Databases and the Character Sets, LC_COLLATE, and LC_CTYPE Information of the Databases?. The default template database is template1.
Query the LC_COLLATE value supported by the character set. For details, see Configuring the Collation of a Database in a Locale.
Change the value of LC_COLLATE to match the character set and create the database again.

Parent topic: FAQ

Previous topic: How Do I View the Created Databases and the Character Sets, LC_COLLATE, and LC_CTYPE Information of the Databases?

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

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.