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.”
Gherkin Language Beyond English: Keywords in Other Languages
The Gherkin language is not limited to English. This post shows the language header, the same scenario in English, French and Hindi, a keyword table, why a team gains from writing in its own language, and the limits found when the keywords are mixed.
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.
Smiley in SSMS: Show Emoji in Results and Database Names
To show a smiley in SSMS, type the emoji inside an N-prefixed string and run the query. This post explains how SQL Server stores each emoji as two characters, why two different emoji can compare as equal, and how to find them in a column. It also shows what happens when an emoji is part of a database name.
Display Rupee Symbol in SSMS and T-SQL With FORMAT
To display rupee symbol and Indian digit grouping in SSMS, format the number with an Indian culture, or use the Unicode character 8377. This post compares en-IN, hi-IN, gu-IN and kn-IN, shows the nvarchar rule that keeps the symbol from turning into a question mark, and formats dates for the same cultures.
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.