高考问答中医个人简历:[求助]关于日文编码问题。
来源：百度文库 编辑：高考问答 时间：2024/04/19 02:59:16
上网也查了很多资料，也知道是编码的问题，存储数据时，提交数据保存后，在Save的页面要加上
<%@language=vbscript codepage=932 %>
932表示的是日文，看了那些文章后，好象这样可以将数据转为日文的Unicode码。现在好了，加上这么一行后，存储数据时，存到数据库（ACCESS2000）的是乱码，而且这些数据记录也无法从前台读出，不知道是不是跟操作系统平台有关[偶用的是XP简体中文操作系统]。
我的疑问是，既然这些数据存在，那么是不是在日文操作系统平台下可以读出呢？
我在本地调试时，所有的前台显示的页面都采用的euc-JP编码，却读不出数据。
求高手解疑~~谢谢！！
你先试一下这两个函数
上面的日文会导致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
读取
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
如果还不好用在下个下面的软件试试..
oBlog3.1 Access数据库日文字符转换程序
适用范围：
本程序只适用于Access数据库，解决日文字符导致搜索时内存溢出的问题
只适用于从3.0beta/3.0/3.1beta1升级到3.1的数据库
直接从3.1版本开始的网站不必执行该程序
使用SQL Server数据库的网站不必执行该程序
注意：
1：请务必备份你的数据库文件！！
2：升级完成后不必重新发布全站
3：升级完成后需要手动压缩一下数据库文件
下载地址：
http://www.oblog.cn/down/oblog31_convertjp.rar