HP 3000 Manuals HP 3000 Manuals
Using the ANSI Character Set The HP 3000 uses the ROMAN8 character set. Most applications running under Microsoft Windows use the 8-bit ANSI (ISO 8859/1) character set to provide support for Western European languages (including American). The first 127 characters are the same for both ROMAN8 and ANSI character sets, so only the extended and special characters are different. If your PC client application uses these extended or special characters, then the data from the database server must be converted from ROMAN8 to ANSI, and the data returning to the database server must be converted from ANSI to ROMAN8. To activate the conversion, use the an parameter in the connection string syntax. Refer to the "SQL.INI File" section in this chapter for complete syntax. The conversion takes place on the PC client. Only bind variables of datatype CHAR and VARCHAR are converted. A bind variable in an SQL statement is associated (bound) to variables defined in a program. A few characters cannot be converted to ROMAN8 and then back to ANSI. For example, when the copyright sign in ANSI is converted to ROMAN8, it is changed to a lowercase "c." When the data is returned to the PC client, the copyright sign cannot be recognized, as it was converted to a "c." The following characters, sent from the PC client, cannot be properly converted from ANSI to ROMAN8 in a round-trip fashion. (The hex designation is listed along with the character name.) * A6 broken bar * A9 copyright sign * AC not sign * AE registered trade mark * B2 superscript 2 * B3 superscript 3 * B8 cedilla * B9 superscript 1 * D7 multiply sign * F7 divide sign Similarly, the following characters, sent from the database server, cannot be properly converted from ROMAN8 to ANSI in a round-trip fashion. (The hex designation is listed along with the character name.) * A9 accent grave * AA circumflex accent * AC tilde accent * BE Dutch guilder * EB uppercase S caron * EC lowercase s caron * EE uppercase Y umlaut * F6 long dash * FC solid box