In MariaDB, COLLATION() is a secondary built in function that returns the collation of a given string.
We provide the string when we call the function.
Continue readingCategory: MariaDB
3 Ways to Get the Collation of a Column in MariaDB
Here are three ways to return the collation of a column in MariaDB.
Continue readingSet the Character Set and Collation of a Table in MariaDB
You can specify the character set and collation at various levels in MariaDB. You can specify them at the connection level, the server level, the database level, the table level, and even the column level.
You can also specify a collation in your queries so that it overrides any collation that has been previously specified at the aforementioned levels.
To set the character set and collation at the table level, use the CREATE TABLE statement or ALTER TABLE statement (depending on whether you’re creating the table or modifying it).
4 Ways to Get the Database Collation in MariaDB
Here are four ways to return the database collation in MariaDB.
Continue readingHow SHOW CHARACTER SET Works in MariaDB
In MariaDB, you can use the SHOW CHARACTER SET administrative SQL statement to return all available character sets in MariaDB.
How SHOW COLLATION Works in MariaDB
In MariaDB, you can use the SHOW COLLATION administrative SQL statement to return all available collations in MariaDB.
Full List of Collations Supported by MariaDB
Below is a full list of collations available in MariaDB.
Continue readingFull List of Character Sets Supported by MariaDB
Below is a full list of character sets available in MariaDB.
Continue readingShow 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.
Continue readingHow 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.