本文介绍使用DBQueryAnalyzer3.02处理从数据库导出文件时遇到的数据记录数异常增加的问题。当文件中包含ASCII值为10的字符时，可能会导致Excel打开时记录数异常增加，通过配置双引号作为字段限定符可以有效解决该问题。
Resolution to the record count increasing of the file exported from DB when ‘0A’ is included in it
DB Query Analyzer 3.02 is up for presented after Chinese Spring Festival. I have been doing software test on it for about a month.
DB Query Analyzer 3.02 mainly has two new functions below:
3.02 version two new characteristics
First, DB Query Analyzer allows users to define the restrict character among single quotation marks, double quotation marks and none. If you reset it in the config window, the query result will take effect right now. However, If you reset the separator between SQL, it will take effect in the new opened SQL edit window.
Second, Some Bug in the process that Stored Procedures and Key Words input by users will be drew different color in DB Query Analyzer is rectified.
DB Query Analyzer 3.02 can help you
As a database application software engineer, I’m good at huge data process including not only the huge data file but huge records database system. Analysis to Billions of records is very normal in my daily job.
In some case, I found it very difficult to get know the reason why the data records became much more than the query result when you open the exported file by MS EXCEL. Also error message was seen when you import the file to some Database System.
After a long time analysis, I know it’s just because character which ASCII value is ten is in it.
This case will never been seen if you define double quotation marks to the character fields in DB Query Analyzer 3.02. After doing this step, you will get the correct record count for the exported file.
DB Query Analyzer 5.03 download URL:
http://xiazai.zol.com.cn/detail/43/420901.shtml
http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_503.rar
DB Query Analyzer Simplified Chinese version 5.03 download URL:
http://xiazai.zol.com.cn/detail/27/264455.shtml
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
