数据库系统开发中字符编码问题的研究  

Research on character code during the development of database system

作　　者：张鹏伟[1] 李建文[1] 

机构地区：[1]陕西科技大学电气与信息工程学院,陕西西安710021

出　　处：《陕西科技大学学报（自然科学版）》2013年第5期139-143,共5页Journal of Shaanxi University of Science & Technology

基　　金：西安市科技局科技创新支撑计划-产学研合作促进计划项目(CXY1121(1))

摘　　要：讨论了数据库系统开发过程中前台、后台与字符编码之间的关系;分析了3种常用字符编码Unicode、ANSI、UTF-8之间的关系以及它们的优缺点;通过实例揭示了数据库系统中由于字符编码的混用可能出现的数据丢失现象,并通过字符编码理论与数据库开发实验结果提出了解决数据丢失问题的方法.运用具体的数据库开发试验,充分地揭示了数据库开发中关于字符编码可能出现的一系列安全问题,说明了字符编码作为基础理论在数据库开发过程中具有不可忽视的重要性.This paper mainly talks about the relationship between the developments of data- base system onstage, backstage and character code mixing. Analyzing the relation and advan- tages among three normal kinds of character encoding Unicode, ANSI and UTF-8. This pa- per uses examples to illustrate the reason of database data losing which is the code mixing in database system, and also gives solutions through the theory of character encoding and ex- perimental results of database system developing. With the specific experiment, this paper fully shows a series of security issue about character encoding and explains the significant im- portance of character encoding as a basic theory during database system.

关 键 词：数据库系统 字符编码 UNICODE ANSI UTF-8 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]