Character strings in UDRs

When your C UDR contains character strings that are sent to the database server, it must perform any required code-set conversion on these strings.

This code-set conversion must handle any differences between the code set of this character string and the code set of the server-processing locale in which the UDR executes.

For example, the DataBlade® API does not perform code-set conversion on the multibyte table name, A1A2A3B1B2, in the following SELECT statement:
mi_exec(conn, "SELECT * from A1A2A3B1B2", 0);

If your UDR might execute in a server-processing locale that does not include a code set that supports characters in your SQL statements, the UDR can explicitly perform code-set conversion between the code sets of the server-processing locale and a specified locale.