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

摘要

讨论了数据库系统开发过程中前台、后台与字符编码之间的关系；分析了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 .