Neoview Character Sets Administrator's Guide (R2.3)

Table of Contents
About This Document.........................................................................................................7
Intended Audience.................................................................................................................................7
New and Changed Information in This Edition.....................................................................................7
Document Organization.........................................................................................................................7
Notation Conventions.............................................................................................................................7
General Syntax Notation...................................................................................................................7
Related Documentation..........................................................................................................................9
Neoview Customer Library...............................................................................................................9
Publishing History................................................................................................................................11
HP Encourages Your Comments..........................................................................................................11
1 Introduction to Neoview Character Sets....................................................................13
Introduction to Neoview Character Set Configurations, Column Character Definitions, and Character
Sets........................................................................................................................................................13
Introduction to Client Locale Character Encoding and Neoview Database Character Encoding.......15
Introduction to Compatible Client Locale Characters and Multiple Client Locale Characters...........15
Neoview Character Set Configurations................................................................................................16
Compatibility Between Neoview ODBC and JDBC Drivers and the Neoview Database....................18
2 How to Select the Correct Neoview Character Set Configuration..........................21
Restrictions on Changing the Neoview Character Set Configuration..................................................21
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.........................................................................................................26
4 Capabilities and Limitations of Neoview Client Applications.................................31
Neoview Transporter Java Client..........................................................................................................31
Neoview Loader....................................................................................................................................31
Neoview DB Admin..............................................................................................................................32
Neoview Management Dashboard Client............................................................................................32
Neoview Command Interface (NCI)....................................................................................................32
Workload Management Services (WMS)..............................................................................................32
5 Troubleshooting Guidelines for Neoview Character Sets Users.............................35
A Character Set Mapping Tables..................................................................................39
B Capabilities and Limitations of Multiple Client Locales in the Unicode
Configuration...................................................................................................................41
C Configuring Neoview Client Applications................................................................43
How Character Encoding Is Implemented on the Neoview Transporter Java Client..........................43
Table of Contents 3