Help Center/
Relational Database Service/
FAQs/
Database Parameter Modification/
How Do I Modify the Collation of an RDS for SQL Server Character Set?
Updated on 2024-10-22 GMT+08:00
How Do I Modify the Collation of an RDS for SQL Server Character Set?
- A database-level collation can be specified during database creation. If it is not specified, an instance-level collation is automatically used. You can change the database-level collation as user rdsuser at any time. You are advised to change the collation on the DAS console.
- Log in to the management console.
- Click in the upper left corner and select a region.
- Click in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, locate the DB instance and click Log In in the Operation column.
Alternatively, click the DB instance name on the Instances page. On the displayed Basic Information page, click Log In in the upper right corner.
- Enter the username and password and click Log In.
- Select the target database and choose SQL Operations > SQL Query. In the displayed SQL window, run required commands.
(In this example, the collation of the test database is set to simplified Chinese.)
use test go ALTER DATABASE test COLLATE Chinese_PRC_CS_AS
Parent topic: Database Parameter Modification
Feedback
Was this page helpful?
Provide feedbackThank 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.
For any further questions, feel free to contact us through the chatbot.
Chatbot