By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t_(col VARCHAR(100));
INSERT INTO t_(col) VALUES (N'☢️');
SELECT * FROM t_;
-- ??
| col |
|---|
| ?? |
CREATE TABLE t(col VARCHAR(100) COLLATE Latin1_General_100_CI_AI_SC_UTF8);
-- collate could be set on column/database/instance level
INSERT INTO t(col) VALUES (N'☢️');
SELECT * FROM t;
-- col
-- ☢️
| col |
|---|
| ☢️ |