Neoview Character Sets Administrator's Guide (R2.4, R2.5)

About This Document
This manual contains the information needed by database administrators and end users to use,
configure, and troubleshoot the Neoview Character Sets feature for Release 2.4.
Intended Audience
This manual is intended for database administrators and other users of the Neoview Character
Sets feature on the Neoview platform.
New and Changed Information in This Edition
This version of the Neoview Character Sets Administrator's Guide contains this new and changed
information:
• Table 1-3 (page 17) describes changes to features of the Neoview character set configuration.
• For updated driver and Neoview platform compatibility, see “Compatibility Between
Neoview ODBC and JDBC Drivers and Neoview Platforms” (page 19).
• To move to Release 2.4, see Chapter 2 (page 21).
• Character string functions now treat each multibyte character in an input string as one
character, regardless of the byte length of the character. See “Behavior of SQL String
Functions” (page 27).
• You can now translate a string from UCS2 to UTF8 (and from UTF8 to UCS2) in the Unicode
configuration, and you can translate a string from SJIS to UCS2 (and from UCS2 to SJIS) in
the SJIS configuration. See the TRANSLATE function in “Behavior of SQL String Functions”
(page 27).
• In SJIS and Unicode configurations, the LIKE predicate now handles an underscore as one
character, regardless of how a character is stored in the database, and now compares character
strings at the character level, not the byte level. See “Guidelines for the LIKE Predicate in
the SJIS and Unicode Configurations” (page 31).
• Syntax error messages now identify the number of characters from the start of the SQL
statement where the error occurred, allowing you to find an invalid character more quickly
with your editor. See “Locating Invalid Characters in Syntax Error Messages” (page 33).
• Table 5-1 (page 39) describes new and revised troubleshooting procedures.
Document Organization
Provides an introduction to the Neoview character set configurations and other
features of the Neoview Character Sets feature for Release 2.4.
Chapter 1 (page 13)
Identifies the criteria for determining which of the three Neoview character set
configurations (ISO88591, SJIS, or Unicode) is correct for a given customer.
Chapter 2 (page 21)
Describes the rules for using SQL language elements such as DDL and DML
statements, character string functions, and SQL identifiers to define and manage
character data in Neoview SQL tables.
Chapter 3 (page 23)
Describes the capabilities and limitations of the Neoview clients with respect to the
three Neoview character set configurations.
Chapter 4 (page 35)
Identifies known troubleshooting issues for end users and their recommended fixes
and solutions.
Chapter 5 (page 39)
Identifies the mapping tables used with the Neoview Character Sets feature and
provides a cross-reference to the document that contains links to these mapping
tables.
Appendix A (page 45)
Intended Audience 7