Wednesday, March 13, 2019

[google-cloud-sql-discuss] Thai language sorting on MySql for google cloud SQL

We use Google Cloud SQL as the database server for a wordpress site.
We use the colation utf8mb4_unicode_520_ci
One of our editors in Thailand pointed out that the Alphabetic sorting is wrong in the results when the db is queried.

thai-wrong-sorting.png



Their suggestion was to
```
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.
```
But this collation is not available in mysql for Google Cloud SQL.
Anyone has any ideas on a solution?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2ef5fed7-5474-4048-bb4b-99858de7a4da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment