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

Table 5-1 Troubleshooting Symptoms, Causes, and Recommended Corrective Actions for Users
(continued)
Recommended Corrective ActionsProbable CausesSymptomsProblem Type
Use only characters that are supported
(compatible) across all the client
workstations. Install all the supported
fonts on every workstation. If a
Neoview ODBC driver is used, it
might also be necessary to configure
the same character set on every
workstation. For more information, see
Appendix B (page 41).
A client workstation attempted to
query character data stored in the
Neoview database that is not
compatible with its configured
character set. In the Unicode
configuration, workstations can
only display character fonts that
have been that have been installed
on them. When you use a
Neoview ODBC driver-connected
application to query the database
in the Unicode configuration, each
client workstation can only view
character data that is encoded in
the character set that is currently
configured on that workstation.
When a client
workstation attempts
to view character data
from a Neoview ODBC
driver-connected query
application, these
symptoms occur:
• A translation error
is generated stating
that you inserted
characters from
another client
workstation that are
not supported on
the retrieving
workstation.
• Replacement
characters (question
marks by default)
are displayed from
the query
application.
Incompatible
client locale
errors when an
ODBC
driver-connected
query
application is
used in the
Unicode
configuration.
• If possible, reduce the size of the
key to conform to the 255-byte limit.
• Otherwise, do not use the NO
PARTITION option, particularly in
tables that store multibyte
characters.
A table with the NO PARTITION
option specified imposes lower
size limits on keys, data blocks,
and table row sizes than does a
hash-partitioned table.
When you create a
table with the NO
PARTITION option
specified and define a
key for a character
column, you get an
error stating that you
have exceeded the
255-byte size limit.
Key size length
limit exceeded
when NO
PARTITION is
specified for a
table
38 Troubleshooting Guidelines for Neoview Character Sets Users