数据库英文字段的中文显示研究

在开发数据库应用的项目中,常涉及到对企业数据库中数据表的各种数据的查询浏览等信息的获取.虽然大型关系数据库均支持中文字段名称的定义,但是数据库表中的字段名称通常仍由英文字符定义.一个大型数据库往往包括数百个数据表,由成千上万个字段组成,而数据的字段名称又必须以中文名称来显示,如果在每个Sql语法中通过as进行中英文的转换,不仅使工作量增大,且一旦程序变化,就需修改每个语法命令,大大降低程序的灵活性.通过建立中英文数据字典维护表,从而建立通用的数据获取函数的方法,解决数据库开发中的上述问题.

DATABASE FIELDS ENGLISH CONVERTING TO CHINESE SHOWS

As we develop the software of database program,it refers to various of condition searches,in order to get lots of information data.Although modern relationship databases support table's fields defined with chinese character code,but fields usually define with english character code.A big database application always makes up several hundred tables and several thousand fields.However fields english have to show with chinese language,if we convert english to chinese using 'as' with SQL command,it will increase our work,furthermore if the application changes in the future,we must modify code in the program.Thus it will decrease database system's flexiblility.In this paper,to solving these questions,we create auxiliary table that storages fields english to chinese comparing records and create general data getting function.