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

Table of Contents
About This Document.........................................................................................................7
Intended Audience.................................................................................................................................7
New and Changed Information in This Edition.....................................................................................7
Document Organization.........................................................................................................................7
Notation Conventions.............................................................................................................................8
General Syntax Notation...................................................................................................................8
Related Documentation........................................................................................................................10
Neoview Customer Library.............................................................................................................10
Publishing History................................................................................................................................11
HP Encourages Your Comments..........................................................................................................11
1 Introduction to Neoview Character Sets....................................................................13
Neoview Character Set Configurations, Column Character Definitions, and Character Sets.............13
Client Locale Character Encoding and Neoview Database Character Encoding.................................15
Compatible Client Locale Characters and Multiple Client Locale Characters.....................................15
Neoview Character Set Configurations................................................................................................16
Compatibility Between Neoview ODBC and JDBC Drivers and Neoview Platforms.........................19
2 Selecting a Neoview Character Set Configuration..................................................21
Criteria for Selecting a Neoview Character Set Configuration............................................................21
Process for Implementing a Neoview Character Set Configuration....................................................22
Rules for Migrating to Neoview Release 2.4.........................................................................................22
3 Using SQL Language Elements to Define and Manage Database Encoding.......23
Rules for Encoding SQL Language Elements.......................................................................................23
Behavior of SQL Functions...................................................................................................................26
Behavior of SQL String Functions.........................................................................................................27
Guidelines for the LIKE Predicate in the SJIS and Unicode Configurations........................................31
Locating Invalid Characters in Syntax Error Messages........................................................................33
Example of a Syntax Error in a Shorter SQL Statement..................................................................33
Example of a Syntax Error in a Multi-Line SQL Statement.............................................................34
4 Capabilities and Limitations of Neoview Client Applications.................................35
Neoview Command Interface (NCI)....................................................................................................35
Neoview DB Admin..............................................................................................................................35
Neoview Loader....................................................................................................................................36
Neoview Management Dashboard.......................................................................................................36
Neoview Manageability Repository.....................................................................................................37
Neoview Transporter Client.................................................................................................................37
Neoview Workload Management Services (WMS)..............................................................................38
5 Troubleshooting Guidelines for Neoview Character Sets Users.............................39
SJIS Character Mismatches...................................................................................................................42
SQL-Side SJIS Character Mismatch Examples................................................................................43
SQL-Side SJIS Character Mismatch Scenarios.................................................................................43
How to Prevent SQL-Side SJIS Character Mismatches...................................................................44
Table of Contents 3