Current processing locale for UDRs
To access a database, a client application first requests a connection to the database server, which must verify that it can access the specified database and establish the connection between the client and this database.
In the process, the database server establishes the server-processing locale to use the duration of the connection. When the client application executes a UDR, this UDR executes on the server computer in the context of the server-processing locale. This locale is often called the current processing locale.
Many user-defined routines handle non-ASCII data correctly even if they were originally written for ASCII data. Some routines, however, might perform abnormally. To globalize your C UDR, you must ensure that your UDR handles the server-processing locale in any GLS-related operations. If the UDR does not properly support the server-processing locale, the routine might return unexpected results or an error message.