allow other than en_US.UTF8 in google_sql_database.collation

[Mats-Elfving]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request.
• Please do not leave +1 or me too comments, they generate extra noise for issue followers and do not help prioritize the request.
• If you are interested in working on this issue or have submitted a pull request, please leave a comment.
• If an issue is assigned to a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Description

ref this answer it would make more sense to either not have the collation as a parameter (as it can have only one value) or to automatically use the template template0 option when a non en_US.UTF8collation is used.

New or Affected Resource(s)

google_sql_database

Potential Terraform Configuration

no changes

References

No response

b/383121904