Abstract: Systems and methods to detect and analyze character set translation errors in an electronic document are provided. One method according to the invention includes detecting a first character string within the electronic document; converting the first character string to a sequence of bytes by use of a first character set; using a second character set to convert the sequence of bytes to a second character string; and detecting whether a length of the second character string is different than a length of the first character string. Detection results are stored in memory for later analysis. Systems according to aspects of the invention perform are configured to perform this and other methods. In one example, the system includes a test scheduler, a test result classifier, an analyzer unit, and a processor coupled to data storage for performing the aforementioned method.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for identifying misrepresented characters in strings of text. A computer system receives text that includes characters identified as being encoded in UTF-8. The characters are represented as code point values, each code point value representing one character in the text. The computer system makes a determination that the text likely includes characters incorrectly converted from Win-1252 to UTF-8 by comparing the code point values that represent the text with test values. Based on the comparison, the computer system identifies sequences of characters in the text that was likely incorrectly converted.

Abstract: A method and system for retrieving data from a database over a network includes: generating an executable statement at a gateway in accordance with a macro language file, where the executable statement comprises one or more a parameter markers; passing the executable statement from the gateway to database software; and passing a value for each parameter marker from the gateway to the database software. The present invention allows the Net.Data gateway to support parameter markers in place of Net.Data variables. This allows the Net.Data gateway to take advantage of the dynamic Structured Query Language (SQL) statement caching feature available with conventional database systems. With the use of this invention, the execution of the SQL statements occurs more rapidly, saving resources and improving performance. Additionally, the Net.Data variables may be automatically replaced with parameter markers, with the Net.Data variables and their values maintained. This provides transparent support for parameter markers.