Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > DECLARE @Temp TABLE > ( > [TheValue] VARCHAR(10) COLLATE Latin1_General_100_CI_AS_SC_UTF8 NOT NULL > ); > > INSERT INTO @Temp ([TheValue]) VALUES (0xF09F91BE); -- UTF-8 bytes > > SELECT * FROM @Temp; > > <pre> > | TheValue | > | :------- | > | 👾 | > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=sqlserver_2019l&rdbms2=sqlserver_2019l&fiddle=1d33e71e8be773f0f2bbd4d8bb497d71)*
back to fiddle