Copy heidiSQL for linux Version Alpha
What follows isn’t for the faint-hearted or the terminal averse. You’ll need to roll up your sleeves and do a bit of manual jiggery-pokery (that’s the official technical term) to get emoji beaming.
If you have the fonts-emojione-svginot font installed you MUST remove it before continuing. Got it?
- Download the Google Noto Colour Emoji font.
This font is distributed as a free .tff file and is licensed under the SIL Open Font License.
Download Google Noto Color Emoji Font
Extract the zip archive (once it’s finished downloading) and move the NotoColorEmoji.tff file to the (hidden) ~/.fonts/ directory in your Home folder. If this folder isn’t there you’ll need to create it.
- Create a font-config
You cannot skip this step.
You need to create the following font-config file so that the Ubuntu desktop (and the apps that run on it) know which emoji font to load by default. Without this you’ll only see colourful emoji for newer characters not covered by ttf-ancient-symbola.
First part to this is to create a fontconfig folder in the local config directory:
mkdir -p ~/.config/fontconfig/
Next, enter the following text into the terminal:
cat << 'EOF' > ~/.config/fontconfig/fonts.conf
Paste the code excerpt below into the Terminal, being careful not to alter a single character:
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE fontconfig SYSTEM "fonts.dtd">
<match>
<test name="family"><string>sans-serif</string></test>
<edit name="family" mode="prepend" binding="strong">
<string>Noto Color Emoji</string>
</edit>
</match>
<match>
<test name="family"><string>serif</string></test>
<edit name="family" mode="prepend" binding="strong">
<string>Noto Color Emoji</string>
</edit>
</match>
<match>
<test name="family"><string>Apple Color Emoji</string></test>
<edit name="family" mode="prepend" binding="strong">
<string>Noto Color Emoji</string>
</edit>
</match>
Type EOF and hit enter to save.
All that’s left to do now is flush the font cache so that apps know there’s a new font to use. Do this by running:
fc-cache -f -v
If you had Google Chrome, Vivaldi, Corebird or any other apps open during this process you (may) need to restart them for the colourful emoji characters to show up.
To test that you installed the font correctly open the following emoji demo page in Google Chrome (or Chromium, Vivaldi, Min, whatever).
Visit the Emoji Demo Page
Issues
There are downsides.
You may find some GTK desktop applications have issues displaying regular text correctly after following this tutorial. Share your experiences in the comments. You can undo the changes by deleting the fontconfig, deleting the Noto Color Emoji font, and flushing the font cache (basically reversing the entire process).
Apps that I’ve noticed don’t play nice when this has been applied include Geary (message body is all garbled), Thunderbird, Geany and some pages in Firefox display incorrectly.