Emoji are obsolete. There, I have written it. I do not entirely believe it.
A few days ago I wrote to a client: “We need to talk about the index strategy.”
JDBC and sendStringParametersAsUnicode: The Hidden Index Scan
Diagnose sendStringParametersAsUnicode conversions, align JDBC parameters with varchar indexes, and preserve required Unicode data.
SQL SERVER – Storing a Non-English String in Table – Unicode Strings
Yesterday I had a meeting with my client Performance Health Check, and they wanted to know how to store a non-English string in a table.
SQL SERVER – Displaying Smiley in SSMS – Emoji
Recently I had an interesting conversation with my client about Emoji in SQL Server. It is possible to create your database with any emoji.
UTF-8 Collations in SQL Server 2019: When They Save Space
Compare UTF-8 collations with NVARCHAR storage for English, European, and Asian text before converting indexes or clients.
PostgreSQL – Storing Unicode Characters is Easy
SQL Server needs NVARCHAR or NCHAR for non-English text. In PostgreSQL, plain VARCHAR stores Unicode characters too, as my quick Russian example shows.
UNISTR and Unicode Escapes in SQL Server 2025
Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.