CREATE TABLE [OperateHistory] (
[OPID] [nvarchar] (50) Primary Key,
[OperateType] [nvarchar] (50)NOT NULL ,
)
GOinsert OperateHistory('501','入库')select * from OperateHistory where OperateType='入库'
结果什么都查不出来???
[OPID] [nvarchar] (50) Primary Key,
[OperateType] [nvarchar] (50)NOT NULL ,
)
GOinsert OperateHistory('501','入库')select * from OperateHistory where OperateType='入库'
结果什么都查不出来???
insert OperateHistory
select '600','入库'
但是Select出来没东西???select * from OperateHistory where OperateType='入库' --这种查询不OK
如果把“入库”改成其他英文如Enterwarehouse之类
select * from OperateHistory where OperateType='Enterwarehouse' --这样的查询是OK的
CREATE TABLE [OperateHistory] (
[OPID] [nvarchar] (50) Primary Key,
[OperateType] [nvarchar] (50)NOT NULL ,
)
GOinsert OperateHistory values('501','入库')select * from OperateHistory where OperateType='入库'--result
OPID OperateType
-------------------------------------------------- --------------------------------------------------
501 入库(1 row(s) affected)
[OPID] [nvarchar] (50) Primary Key,
[OperateType] [nvarchar] (50)NOT NULL ,
)
GOinsert OperateHistory values(N'501',N'入库')select * from OperateHistory where OperateType=N'入库'--result
OPID OperateType
-------------------------------------------------- --------------------------------------------------
501 入库(1 row(s) affected)
[OPID] [nvarchar] (50) Primary Key,
[OperateType] [nvarchar] (50)NOT NULL ,
)
GOinsert OperateHistory values(N'501',N'入库')select * from OperateHistory where OperateType=N'入库'--插入nvarchar类型的字符数据前面得加N
谢谢楼几位热心解答再问下:加这个N是什么意思?
----
表示 UNICODE 字符
应该是:
insert OperateHistory values('501','入库')
ater database dbname collate Chinese_PRC_CI_AS--重建排序