Help Center > > FAQs> Database Parameter Modification> How Do I Modify the Collation of RDS for SQL Server?
How Do I Modify the Collation of RDS for SQL Server?
Updated at: Jun 09, 2021 GMT+08:00
- An instance-level collation can be specified only during instance creation. After the DB instance is created, the collation cannot be modified. To modify the instance-level collation, you need to create a DB instance and then restore data to the created DB instance.
- A database-level collation is specified during database creation. If it is not specified, the instance-level collation is automatically used. You can modify the database-level collation as user rdsuser at any time.