Question

asp用access like查询的时候出错，显示内存溢出。

好像是因为有日文片假名的原因，不过不知道怎么解决。

Answer 1

这个问题是ACCESS固有的BUG，不能从根本上解决，建议将日文通过字符变换进行存储，显示时再转换过来，方法有：
server.HTMLencode()
server.HTMLdecode()

或者有最简单的办法：escape()、unescape()

实例：
如要在ACCESS数据库中存储日文片假名XXX，则存储时使用：escape(xxx)，取出时用unescape(xxx)。
=====================
如果以上不能解决问题，建议用下面的函数进行变换：
Function EncodeJP(StrHTML)
StrHTML=Replace(StrHTML,"ガ","")
StrHTML=Replace(StrHTML,"ギ","")
StrHTML=Replace(StrHTML,"ア","")
StrHTML=Replace(StrHTML,"ゲ","")
StrHTML=Replace(StrHTML,"ゴ","")
StrHTML=Replace(StrHTML,"ザ","")
StrHTML=Replace(StrHTML,"ジ","")
StrHTML=Replace(StrHTML,"ズ","")
StrHTML=Replace(StrHTML,"ゼ","")
StrHTML=Replace(StrHTML,"ゾ","")
StrHTML=Replace(StrHTML,"ダ","")
StrHTML=Replace(StrHTML,"ヂ","")
StrHTML=Replace(StrHTML,"ヅ","")
StrHTML=Replace(StrHTML,"デ","")
StrHTML=Replace(StrHTML,"ド","")
StrHTML=Replace(StrHTML,"バ","")
StrHTML=Replace(StrHTML,"パ","")
StrHTML=Replace(StrHTML,"ビ","")
StrHTML=Replace(StrHTML,"ピ","")
StrHTML=Replace(StrHTML,"ブ","")
StrHTML=Replace(StrHTML,"ブ","")
StrHTML=Replace(StrHTML,"プ","")
StrHTML=Replace(StrHTML,"ベ","")
StrHTML=Replace(StrHTML,"ペ","")
StrHTML=Replace(StrHTML,"ボ","")
StrHTML=Replace(StrHTML,"ポ","")
StrHTML=Replace(StrHTML,"ヴ","")
EncodeJP=StrHTML
End Function

将这个数据库循环变换
set rs=server.createObject("adodb.recordset")
rs.open "查询语句",conn,1,2
do while not rs.eof
rs("content")=EncodeJP( rs("content"))'此处为举例
rs.update
rs.movenext
loop
rs.close
set rs=nothing

Answer 2

应该不会有这个问题的，你把你的代码贴出。记得acess的like用法和sql的不一样~通配符不一样