Database[MSSQL] like %%中文不匹配問題(必知)新手常犯,常忘記的匹配問題。主要是轉碼,需要在like後面添加個N,N轉換字符串爲nchar,nvarchar。SELECT [Type] ,[Title] FROM [TableName] WHERE [Title] LIKE N'%標題%'