Code page conversion can occur in the following situations:
- When a client or application accessing a database is running in
a code page that is different from the code page of the statement
being invoked:
You can minimize or eliminate client/server character
conversion in some situations. For example, you could:
- Create a database on Windows using
code page 850 to match a Windows client
application environment that predominately uses code page 850.
- Create a database on AIX® using
code page 850 to match a client application environment that predominately
uses code page 850.
- Avoid specifying the CCSID option when creating tables and the
PARAMETER CCSID option when creating routines.
- When a client or application importing a PC/IXF file runs in a
code page that is different from the file being imported.
This
data conversion will occur on the IBM® data server client machine
before the client accesses the database
server.
Additional data conversion might take place if the application is
running in a code page that is different from the code page of the
database (as stated in the previous point).
Data conversion,
if any, also depends on how the import utility was called.
- When DB2 Connect™ is
used to access data on a host, z/OS®,
or System i® server.
In this case, the data receiver converts the character data. For example,
data that is sent to DB2® for z/OS is
converted to the appropriate coded character set identifier (CCSID)
by DB2 for z/OS.
The data sent back to the DB2 Connect machine
from DB2 for z/OS is
converted by DB2 Connect.
Character conversion will
not occur for: