How Do I Modify the Collation of RDS for SQL Server?

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 and a project.
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
```