解决sql server localdb中文乱码问题

使用以下查询语句(引号部分改为自己数据库文件路径)并将需要输入中文的字段改为nvarchar类型即可。

alter database "F:codeASP.NETMyBookShopMyBookShopApp_DataMyBookShop.mdf" set single_user with rollback immediate ; 
go

alter database "F:codeASP.NETMyBookShopMyBookShopApp_DataMyBookShop.mdf" collate Chinese_PRC_CI_AS ; 
go

alter database "F:codeASP.NETMyBookShopMyBookShopApp_DataMyBookShop.mdf" set multi_user;

expand_less