Ok, nothing complex, crazy, or high-concept today. Just a reminder that stuff like the following is possible without any effort with your database of choice (including HANA, of course):
This does not stop if you want to dig into query performance.
This is what the EXPLAIN PLAN looks like:
And that’s it.
Stay safe, stay healthy, and stay kind.
P.S.
What I have described in this post and the fact that you are reading it now are heavily correlated.
WordPress, the blog platform that I use to host this blog, uses MySQL to store the contents of the posts. This includes the Unicode symbols I used for the emojis in the text.
Then WordPress, a PHP application, needs to read this from the MySQL database via ODBC, process it correctly, and produce an HTML page that it sends to the browser.
The browser, in turn, has to decode and render the Unicode characters correctly.