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;