UTF-8 No Repo

CREATE DATABASE YourDatabase COLLATE Latin1_General_100_CI_AS_SC_UTF8;
GO
USE YourDatabase;
GO

CREATE TABLE dbo.YourTable (SomeID int IDENTITY(1,1),
                            YourString varchar(100));
GO

INSERT INTO dbo.YourTable (YourString)
VALUES('نورديا');
GO
DECLARE @YourString varchar(100);
SET @YourString = 'نورديا';

INSERT INTO dbo.YourTable(YourString)
SELECT @YourString;
GO

SELECT SomeID,
       YourString
FROM dbo.YourTable;
GO

USE master;
GO
DROP DATABASE YourDatabase;
GO