The Ultimate Guide to High Availability with MariaDB

Comments - Setting Character Sets and Collations

6 years, 10 months ago Ian Gilfillan
Re: Setting Character Sets and Collations

These evaluate as equivalent in the default collation, utf8mb4_general_ci

If you change the collation to utf8mb4_bin (in this example just for the connection), this will not be the case:

SET collation_connection = 'utf8mb4_bin';

select 'var'='vår';
+--------------+
| 'var'='vår'  |
+--------------+
|            0 |
+--------------+
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.