Entering Non English Text into SQL Server

The trick for entering non English text into a record is to put an N before the single quote. this designates it as Unicode:

---

Use AdventureWorks


Insert into Customer(customerID,LastName, FirstName, ModifiedDate)
Values(30003,N'Κονγεροσ',N'Στεφενοσ', GETDATE())

Select * from Customer where CustomerID=30003

---