SQL Server/T-SQL Tutorial/Data Types/Unicode

Материал из SQL эксперт
Перейти к: навигация, поиск

Unicode Character Strings

   <source lang="sql">

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.ru", N"N/a") 6> GO 1> 2> drop table Contacts_2; 3> GO 1></source>