In MySQL we can use the SHOW COLLATION statement to return all collations supported by the server. By default it returns all available collations, but we can filter the output down to just those collations that we’re interested in.
Tag: collation
3 Ways to Get the Collations Available in MariaDB
If you need to find the collations that are available in your MariaDB installation, check out the following three methods.
Continue readingSet the Character Set and Collation of a Column 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.
Continue reading2 Ways to Get the Character Sets Available in MariaDB
If you need to find the character sets that are available in your MariaDB installation, check out the following two methods.
Continue readingHow COERCIBILITY() Works in MariaDB
In MariaDB, COERCIBILITY() is a system function that returns the collation coercibility value of its string argument.
It defines how collations will be converted in the case of collation conflict. In such conflicts, an expression with a higher coercibility is converted to the collation of an expression with a lower coercibility.
Continue reading3 Ways to Show the Collation for your Connection in MariaDB
When you run a query against a MariaDB database, MariaDB uses a bunch of system variables to determine which character set and collation to use whenever queries are run. If the client uses a different character set to the server, then MariaDB can translate it into an appropriate character set and collation.
When sending the query results back to the client, MariaDB can translate these results back to a different character set altogether if required. MariaDB uses system variables to determine which character sets and collations to use at each of these steps.
Here are three ways to show the connection collation in MariaDB.
Continue readingSet the Character Set and Collation of a Database 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 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 database level, use the CREATE DATABASE statement or ALTER DATABASE statement (depending on whether you’re creating the database or modifying it).
3 Ways to Get the Server Collation in MariaDB
Here are three ways to show the server collation in MariaDB.
Continue readingHow COLLATION() Works in MariaDB
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 reading3 Ways to Get the Collation of a Column in MariaDB
Here are three ways to return the collation of a column in MariaDB.
Continue reading