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.