既然选择了php为什么不选择mysql?
内存溢出,那跟操作系统也有关系。怕是不好解决。

解决方案 »

  1.   

    卡纳可能在access中可以直接执行不
      

  2.   

    本人决定用最简单的笨方法: 
    Function EncodeJP(StrHTML) 
    If Not StrHTML="" Then 
    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,"ヴ","ヴ") 
    End If 
    EncodeJP=StrHTML 
    End Function 
    经测试——居然OK了! 
    =========================================== 
    --------------------------------------------------- 
    ガギグゲゴザジズゼゾダヂヅデドバビブベボパピプペポヴ 
    --------------------------------------------------- 上面的日文会导致access在搜索时出错,就是内存溢出,在sql下不会有这种问题,要在access下解决的话在储存和读取时用下面的函数 
    储存 
    Function jp2code(CodeStr) 
    jp2code=Replace(Replace(Replace(Replace(Replace(CodeStr,"ガ","j30AC"),"ギ","j30AE"),"グ","j30B0"),"ゲ","j30B2"),"ゴ","j30B4") 
    jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"ザ","j30B6"),"ジ","j30B8"),"ズ","j30BA"),"ゼ","j30BC"),"ゾ","j30BE") 
    jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"ダ","j30C0"),"ヂ","j30C2"),"ヅ","j30C5"),"デ","j30C7"),"ド","j30C9") 
    jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"バ","j30D0"),"ビ","j30D3"),"ブ","j30D6"),"ベ","j30D9"),"ボ","j30DC") 
    jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"パ","j30D1"),"ピ","j30D4"),"プ","j30D7"),"ペ","j30DA"),"ポ","j30DD") 
    jp2code=Replace(jp2code,"ヴ","j30F4") 
    End Function 
    读取 
    [code] 
    Function code2jp(CodeStr) 
    code2jp=Replace(Replace(Replace(Replace(Replace(CodeStr,"j30AC","ガ"),"j30AE","ギ"),"j30B0","グ"),"j30B2","ゲ"),"j30B4","ゴ") 
    code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30B6","ザ"),"j30B8","ジ"),"j30BA","ズ"),"j30BC","ゼ"),"j30BE","ゾ") 
    code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30C0","ダ"),"j30C2","ヂ"),"j30C5","ヅ"),"j30C7","デ"),"j30C9","ド") 
    code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30D0","バ"),"j30D3","ビ"),"j30D6","ブ"),"j30D9","ベ"),"j30DC","ボ") 
    code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30D1","パ"),"j30D4","ピ"),"j30D7","プ"),"j30DA","ペ"),"j30DD","ポ") 
    code2jp=Replace(code2jp,"j30F4","ヴ") 
    End Function