Follow @DecryptoBL on Twitter.
Follow @bwhli on Instagram.

How to Fix WordPress Character Encoding

November 19, 2018

After a recent update to my About page, I saw that Japanese characters were being rendered as question marks. Since Japanese characters were immediately changed to question marks after hitting the “Update” button in the WordPress editor, I quickly ruled out a font-related bug as the cause of the issue. After some Googling and subsequent database exploration, I discovered that my web host’s default database character set is latin1 (ISO-8859-1), which doesn’t support Japanese characters.

To fix the default character set, I downloaded an SQL dump of my database and duplicated it for backup purposes. Next, I opened the SQL file in Coda 2. If you don’t have Coda 2, any other text editor should work as well.

Next, I replaced all instances of DEFAULT CHARSET=latin1 with DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci. This changes both the default character set and collation properties of the database.

Finally, I ensured my wp-config.php settings were on the same page as my database by adding these two lines after my database hostname declaration.

define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', 'utf8mb4_unicode_ci');

Problem fixed! Japanese works just fine now.

BitMEX Research’s in-depth dissection of EOS →

November 19, 2018

The level of detail in this analysis of the EOS project is incredible. I’m going to need a week or two to digest the whole thing, but here’s the conclusion.

From this comprehensive analysis of the EOS system, it has become apparent that in order for EOS to be able to successfully act as a foundational base layer protocol, it needs to re-architect a significant portion of its infrastructure. EOS can potentially act as a side chain appended to other more foundationally secure networks, though the system would need to be rebuilt in order to address the problems detailed in this report.

So, EOS, a $4 billion ICO, needs to redesign its whole architecture? Yikes.

« Permalink »

Hi dad, sorry I’m late! 📷

November 18, 2018

One of my favorite shots from a trip to Gujo earlier this year.

Camera: Fujifilm X-Pro2
Lens: Fujinon XF 56mm f/1.2 R

« View on Instagram »

Autumn in Tokyo

November 18, 2018

I’ve visited Japan nearly 20 times in the past two years, but never during autumn. Now that I live here, I finally got a chance to witness the changing of the seasons at Aoyama-itchome (青山一丁目).

Continue Reading →

People still want to work in crypto and blockchain →

November 18, 2018


According to figures provided to CoinDesk from one of the largest jobs sites,, searches for roles involving bitcoin, blockchain and cryptocurrency dropped by 3.06 percent from October 2017 to October 2018. Meanwhile, employer interest in such jobs – that is, the number of job postings – increased by 25.49 percent over the same period.

I wonder how many of those job postings are for real positions with real compensation. A quick glance at reveals that many blockchain projects are still offering compensation in the form of “% of ICO funds raised”, “profit sharing”, “XYZ token”, or just “competitive”.

Also, there is a distinct lack of ethical behavior when it comes to financial compensation in this industry. I’ve experienced this myself with a previous employer that was consistently 2-3 weeks late with my paycheck. In another job, the compensation was pegged to the company’s token instead of a more stable asset like BTC or a stablecoin. This in itself isn’t necessarily a bad thing, but the employer refused to recalculate compensation during the bear market. Do you think contractors are going to put out the same quality of work when their compensation is no 95% lower in value? I don’t think so.

« Permalink »


Find me on Twitter, or send me an email.