Data that the database server converts

When the database server transfers data to and from its operating-system files, it handles any differences in the code sets of the server-processing locale and the server locale.

The database server handles these differences as follows:
  • If these two code sets are the same, the database server can read from or write to its operating-system files in the code set of the server locale.
  • If these two code sets are different and the HCL® OneDB® code-set conversion exists between them, the database server automatically performs code-set conversion when it reads from or writes to its operating-system files.

    For code-set conversion to resolve the difference in code sets, the server locale must support the actual code set that the database server used to create the file. For more information, see Make sure that your product supports the same code set.

  • If these two code sets are different, but no HCL OneDB code-set conversion exists, the database server cannot perform code-set conversion.

    If the database server reads from or writes to an operating-system file for which no code-set conversion exists, it uses the code set of the server-processing locale to perform the read or write operation.