请问这句SQL语句是什么意思?
strSqlModify = "UPDATE tblNewspaperInfo SET NewspaperInfoName = N'" + strNewspaperInfoName + "', NewspaperInfoURI = N'" + strNewspaperInfoURI + "',";strSqlModify += "NewspaperInfoAbstract = N'" + strNewspaperInfoAbstract + "', NewspaperInfoCounter = " + intNewspaperInfoCounter + ", NewspaperInfoLogo = N'" + strNewspaperInfoLogo + "', NewspaperInfoUpdateTime = GETDATE() WHERE (NewspaperInfoID = " + intNewspaperInfoID.ToString() + ")";什么意思?里面的“N’”是什么?
参考答案:字符串前面的N代表:将字符串强制转换成扩展字符型
如,原来是char类型,则转换成nchar类型
原来是varchar类型,则转换成nvarchar类型
扩展字符型支持包括unicode编码在内的各类字符,而普通字符型则不支持