maria-discuss team mailing list archive

[Hartmut Holzgraefe <hartmut@xxxxxxxxxxx>]

On 10.10.19 15:52, Björn Keil wrote:

> SHOW VARIABLES LIKE 'character%':
> character_set_client utf8
> character_set_connection utf8
> character_set_database utf8
> character_set_filesystem binary
> character_set_results utf8
> character_set_server latin1
> character_set_system utf8
> character_sets_dir /usr/share/mysql/charsets/
> 
> As you can see here, MariaDB does not take the character '🙋' (
> https://www.fileformat.info/info/unicode/char/1f64b/index.htm ) and
> instead replaces it with four question marks and I have no idea why.

'🙋' is in the extended unicode plane, and so needs 4 bytes when
using UTF-8 encoding. Classic "utf8" charset only supports unicode
code points that use up to 3 bytes when UTF-7 encoded.

For emoticons etc. you need to use the newer utf8mb4 character set
instead.

-- 
Hartmut Holzgraefe - Principal Support Engineer (EMEA)
MariaDB Corporation - http://www.mariadb.com/