We have an application where we use Google Cloud SQL (mysql) as database server. The databases are in the collation: utf8mb4_unicode_520_ci A user of the application from Thailand reported that their content appears in wrong ordering and demonstrated: Wrong alphabetic sorting in Thai
They also suggested this:
modify 'Collate' of our database from 'utf8mb4_unicode_520_ci' or whatever to 'utf8mb4_thai_520_w2' which is available already in Maria DB 10.1.15 or above version
We have a different database per instance. Each database needs to work well in a specific language, so it is not a problem if we changed the collation of their database.
But, I don't see this (or any other Thai related) collation available in MySQL inside cloudSQL.
Anyone knows: a) If any other available collation would do the trick? b) How one could go to a different version of mysql that supports this (or any other working well in thai) collation?
Thanks