向英文操作系统下的英文sqlserver数据库写入中文要在N,我用的参数怎么办?该怎么写?(象如下语句,要怎么写?才能将中文写入英文sqlserver而不乱码?
string strInsert = "insert into sxmember(uid,password, truename) values(@uid,@password,@truename)";
SqlParameter objUid = new SqlParameter("@uid", strUid);
SqlParameter objPassWord = new SqlParameter("@password",strMD5);
SqlParameter objTrueName = new SqlParameter("@truename",strTrueName);
string strInsert = "insert into sxmember(uid,password, truename) values(@uid,@password,@truename)";
SqlParameter objUid = new SqlParameter("@uid", strUid);
SqlParameter objPassWord = new SqlParameter("@password",strMD5);
SqlParameter objTrueName = new SqlParameter("@truename",strTrueName);
strTrueName.value = "N''sometruename''"
然后在附值的时候在变量的前面加上 N'字符串'
这样试试
set ttt=server.createobject("adodb.stream")
ttt.charset="utf-8"