向数据库中插入乱码的问题

Question

use Northwindupdate Categories set description='[ʌm''brelə]' select * from dbo.Categories where categoryid=8怎么搞？

Answer 1

原来N是干这个的？谢谢 小liang

Answer 2

declare @tb table(id int identity(1,1),col nvarchar(100))
insert @tb select 'adf'update @tb set col=N'[ʌm''brelə]' select * from @tb
/*
id          col                                                                                                  
----------- ---------------------------------------------------------------------------------------------------- 
1           [ʌm'brelə]
*/

Answer 3

create table tb([Name] nvarchar(100))
insert tb select N''