#12003/6/16 14:26:23
语句是:
SELECT id,mcheng FROM dwei Where mcheng Like '%研究%' order by id desc
数据库结构如下:
[id] [int] IDENTITY (1, 1) NOT NULL ,
[mcheng] [nvarchar] (255) COLLATE Chinese_PRC_CI_AI_WS NULL ,
[tel] [nvarchar] (50) COLLATE Albanian_BIN NULL ,
[fax] [nvarchar] (50) COLLATE Albanian_BIN NULL ,
[beizhu] [ntext] COLLATE Chinese_PRC_BIN NULL ,
数据库中明明有几条记录,字段 mcheng 中包含 :“研究”
可是无论在程序还是在 sql2000 中都提示检索到 0 条。请高手指点!!!