Are there currently any limitations on what languages we can store in YSQL?

[Question posted by a user on YugabyteDB Community Slack ]

What I mean by language support is the ability to store data in YSQL in multiple languages. For example, English, French, German, Japanese, Chinese, etc.

YugabyteDB supports UTF-8 encoding, but not collation (github issue). It can store data just fine. But if a different-language user creates an ASC/DESC index on a first name, the names will be ordered in UTF-8 binary order, rather than whatever order their alphabet dictates.

yugabyte=# SHOW SERVER_ENCODING;
 server_encoding
-----------------
 UTF8
(1 row)

yugabyte=#  SHOW CLIENT_ENCODING;
 client_encoding
-----------------
 UTF8
(1 row)
yugabyte=# CREATE TABLE txt (t text);
CREATE TABLE
yugabyte=# INSERT INTO txt VALUES ('детская считалочка'), ('兒童數'), ('lasten lukumäärä');
INSERT 0 3
yugabyte=# SELECT * FROM txt;
         t
--------------------
 兒童數
 детская считалочка
 lasten lukumäärä
(3 rows)