In MariaDB, you can use the SHOW COLLATION administrative SQL statement to return all available collations in MariaDB.
DBMS
Database Management Systems
Full List of Collations Supported by MariaDB
Below is a full list of collations available in MariaDB.
Full List of Character Sets Supported by MariaDB
Below is a full list of character sets available in MariaDB.
Show the Collation in MariaDB
In MariaDB, collation can be applied at many levels. Collation can be applied at the server level, the connection level, the database level, the table level, and even at the column level.
It’s also possible to specify a collation at the query level, so that it will override any collation that has been applied at the database, table, or column levels.
MariaDB provides a number of options for returning the collation at the various levels.
How CHAR() Works in MariaDB
In MariaDB, CHAR() is a built-in string function that returns characters based on their code values.
CHAR() accepts one or more integers. It then returns a string consisting of the characters given by the code values of those integers.
How CHR() Works in MariaDB
In MariaDB, CHR() is a built-in string function that returns a character based on the code values provided as an argument.
MongoDB sort()
In MongoDB, the cursor.sort() method specifies the order in which the query returns matching documents.
The sort() method accepts a document that specifies the field to sort, and the sort order. The sort order can be either 1 for ascending or -1 for descending.
You can also specify { $meta: "textScore" } when doing $text searches, in order to sort by the computed textScore metadata in descending order.