SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰

by

This is collation dependant.

Matches empty string

SELECT 1 where N'' = N'🍰'  COLLATE latin1_general_ci_as

Doesn’t match empty string

SELECT 1 WHERE N'' = N'🍰'   COLLATE latin1_general_100_ci_as

The 100 collations are more up-to-date (though still not bleeding edge, they have been available since 2008) and you should use more modern collations unless you have some specific reason not to. The BOL entry for 100 collations specifically calls out

Weighting has been added to previously non-weighted characters that
would have compared equally.

More Related Contents:

  1. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  2. When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
  3. SQL Server – error when creating stored procedure
  4. How can foreign key constraints be temporarily disabled using T-SQL?
  5. How can I escape square brackets in a LIKE clause?
  6. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  7. Datatype for storing ip address in SQL Server
  8. Is there a way to loop through a table variable in TSQL without using a cursor?
  9. Maximum size of a varchar(max) variable
  10. best way to convert and validate a date string
  11. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  12. Is there a way to simplify a NULL compare of 2 values
  13. TSQL Try / Catch within Transaction or vice versa?
  14. What is the maximum number of characters that nvarchar(MAX) will hold?
  15. TSQL: Create a view that accesses multiple databases
  16. Sequence as default value for a column
  17. Aggregate bitwise-OR in a subquery
  18. How do I flush the PRINT buffer in TSQL?
  19. OR Operator Short-circuit in SQL Server
  20. How to change default language for SQL Server?
  21. Cannot bulk load. Operating system error code 5 (Access is denied.)
  22. comparing a column to a list of values in t-sql
  23. Does query plan optimizer works well with joined/filtered table-valued functions?
  24. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  25. @@ERROR and/or TRY – CATCH
  26. “If not exists” fails on SQL CE
  27. Does the `nodes()` method keep the document order?
  28. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  29. Generate MD5 hash string with T-SQL
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment