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.
    1. Log in to the management console.
    2. Click in the upper left corner and select a region.
    3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
    4. 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.

    5. Enter the username and password and click Log In.
    6. 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