In MariaDB, CHARSET() is a secondary built in function that returns the character set of a given string.
We provide the string when we call the function.
Set 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).
How the BINARY Operator Works in MariaDB
In MariaDB, the BINARY operator casts the string following it to a binary string.
The BINARY operator enables you to do a column comparison byte by byte rather than character by character. This causes the comparison to be case sensitive even if the column isn’t defined as BINARY or BLOB. It also means that leading/trailing spaces become significant.
How BIT_LENGTH() Works in MariaDB
In MariaDB, BIT_LENGTH() is a built in string function that returns the length of the given string argument in bits.
You provide the string as an argument when you call the function.
3 Ways to Get the Server Collation in MariaDB
Here are three ways to show the server collation in MariaDB.
How BIN() Works in MariaDB
In MariaDB, BIN() is a built in string function that returns a string representation of the binary value of the given longlong (i.e. BIGINT) number.
You provide the longlong number when you call the function.
How 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.
3 Ways to Get the Collation of a Column in MariaDB
Here are three ways to return the collation of a column in MariaDB.
Set 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.