MySQL Character Sets & Collation

In this post, we will focus on a specific type of character set and encoding, MySQL CHARSET & COLLATION.  I also recommend checking out the earlier post on character encoding for beginners. Have you ever wondered why some non-English characters with accents or Chinese characters such as “豆贝尔维 ” showing as question marks ���� on…

Character Encodings for Beginners

Character encoding governs how characters travel from databases to web browsers and back again. It has a long and winding history behind characters and their encoding. Byte & Character A byte has 8 bits that can represent 256 different values. That’s more than enough for all the English characters plus additional numerical digits, common punctuation…

Demystifying APIs

Have you ever heard the term “API” and wondered what it is? What is API? Technically, API stands for Application Programming Interface. It is a set of programming codes that facilitates data transmission between software systems.  It is not a software program, or even some type of beer but technical specifications that describe how to exchange data from…

The Single Best Web Browser Debug Trick You Should Know

In today’s modern browsers such as Google Chrome, Firefox, Safari, and Microsoft Edge, there is a lesser-known trick that could 10 X increase your client-side debug skills for AKA javascript and CSS. In browser, to toggle Inspecting Element for a web page, here is usually how it is done: Locate page element for inspection on…

JSON in Plain English

    JSON is an open standard, lightweight data-interchange format. It stands JavaScript Object Notation. JSON is extremely common and useful in the modern webs for read and write on a website.  Before JSON, there is XML, which has much overhead and much more difficult to parse than JSON, which is not only easy for humans…