Help Center> Relational Database Service> FAQs> Database Parameter Modification> How Do I Modify the Character Set Collation of RDS for SQL Server?

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

  • 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 character set 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.