Unicode Character Strings : Unicode « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. Unicode

7>
8> Create table Contacts_2(ContactId nchar(8),
9>      Name nvarchar(50),
10>      Note ntext,
11>      Resume nvarchar(max))
12> go
1>
2> --Unicode character constants are also delimited with quotes but are prefixed with N?
3>
4> insert into Contacts_2 (Contactld, Name, Note, Resume)
5>      values (N'CO-92-81', N'Tom Jones', N'Tom@trigonblue.com', N'N/a')
6> GO
1>
2> drop table Contacts_2;
3> GO
1>