Q. How do I specify the character set to be used when passing a CSTRING() to a UDF?
A. You specify the character set for a CSTRING() in a UDF using the "character set" keyword.
Example:
DECLARE EXTERNAL FUNCTION foo
CSTRING(80) CHARACTER SET UNICODE_FSS
RETURNS CSTRING(80) CHARACTER SET UNICODE_FSS FREE_IT
ENTRY_POINT 'my_function' MODULE_NAME 'my_library';
Note: Specifying the character for a field in a table, or variable in a stored procedure or trigger works similarly.
Table Example:
CREATE TABLE MYTABLE (MYFIELD CHAR(10) CHARACTER SET UNICODE_FSS);
Stored Procedure example:
CREATE PROCEDURE MYPROC RETURNS (MYVAR CHAR(10) CHARACTER SET UNICODE_FSS)
AS BEGIN
MYVAR = 'foo';
END;
Last Modified: 07-APR-03