“军卫一号”后台数据库字符集转换研究

摘要

目的:将“军卫一号”后台数据库字符集从ASCⅡ码转换成ZHS16GBK码,有效降低数据维护的安全隐患,并支持更为广泛的Web应用.方法:采用Oracle提供的字符集扫描工具,结合“军卫一号”后台数据结构,搭配使用数据导入导出工具,完成“军卫一号”后台数据库字符集的转换工作.结果:成功将“军卫一号”数据库字符集从单字节编码ASCⅡ转换成为双字节编码ZHS16GBK,没有出现任何乱码及数据丢失.结论:“军卫一号”后台数据库由于历史原因采用ASCⅡ编码带来诸多问题和安全隐患,研究一套切实可行且方便的方法实现字符集的准确转换,可有效提高“军卫一号”数据库的可扩展性和安全性.%Objective To effectively improve the security of database administration and support more extensive web application by converting database ASCII character set into ZHS16CBK one in No. 1 Military Medical Project. Methods By using the character set scanner and data exp/imp tools, character set conversion was realized based on data organization in No.1 Military Medical Project. Results The ASCII character set was converted into ZHS16GBK one and no messy code and data loss appeared. Conclusion The ACSII character set in No.l Military Medical Project has brought many problems and potential dangers for many years. The practicable and convenient method of character set conversion without any errors can improve the expansibility and security of database in No.l Military Medical Project. [Chinese Medical Equipment Journal,2011,32(12) :56-57,59]