Add emoji / emoticon to SQL Server table

by

Use NVARCHAR(size) datatype and prefix string literal with N:

CREATE TABLE #tab(col NVARCHAR(100));

INSERT INTO #tab(col) VALUES (N'👍 🖒 🖓 🖕 🗑 🛦 ⁉ 😎 😔 😇 😥 😴 😭');

SELECT *
FROM #tab;

db<>fiddle demo

Output:

╔═════════════════════════════════╗
║              col                ║
╠═════════════════════════════════╣
║ 👍 🖒 🖓 🖕 🗑 🛦 ⁉ 😎 😔 😇 😥 😴😭 ║
╚═════════════════════════════════╝

EDIT:

SQL Server 2019 and forward supports UTF-8 collation:

CREATE TABLE t(col VARCHAR(100) COLLATE Latin1_General_100_CI_AI_SC_UTF8);
-- column's data type is VARCHAR!
-- collate could be set on column/database/instance level

INSERT INTO t(col) VALUES (N'☢️');

SELECT * FROM t;
-- col
-- ☢️

db<>fiddle demo – SQL Server 2019

More Related Contents:

  1. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  2. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  3. Unpivot with column name
  4. How can I delete using INNER JOIN with SQL Server?
  5. Is there a way to access the “previous row” value in a SELECT statement?
  6. What this query does to create comma delimited list SQL Server?
  7. SQL Server – Return value after INSERT
  8. SQL NVARCHAR and VARCHAR Limits
  9. Split function equivalent in T-SQL?
  10. Querying data by joining two tables in two database on different servers
  11. Convert varchar into datetime in SQL Server
  12. sql query to return differences between two tables
  13. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  14. Where value in column containing comma delimited values
  15. How to find all connected subgraphs of an undirected graph
  16. Check if a row exists, otherwise insert
  17. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  18. How to use table variable in a dynamic sql statement?
  19. SQL query to split column data into rows
  20. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  21. SQL Server : dynamic pivot over 5 columns
  22. How to select the last record of a table in SQL?
  23. Create Trigger to log SQL that affected table?
  24. How to create table using select query in SQL Server?
  25. Transfer data from one database to another database
  26. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  27. How to write UPDATE SQL with Table alias in SQL Server 2008?
  28. SQL Server 2008- Get table constraints
  29. Restrict an SQL Server connection to a specific IP address
  30. Execute Dynamic Query with go in sql

Leave a Comment