Here are two options for getting a list of character sets that are available in MySQL.
Continue readingTag: character sets
An Overview of the SHOW CHARACTER SET Statement in MySQL
In MySQL we can use the SHOW CHARACTER SET statement to return all available character sets. We can also use it to narrow the output down to just those we’re interested in.
Set 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 readingHow CHARSET() Works in MariaDB
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.
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 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).
How 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.
Full List of Character Sets Supported by MariaDB
Below is a full list of character sets available in MariaDB.
Continue readingHow to Return a List of Available Character Sets in MySQL
You can run the following statement to return a list of available character sets in MySQL:
SHOW CHARACTER SET;
This returns a list displaying the character set name, a description, its default collation, and its maximum length.
Continue reading