community.borland.com

Article #29842: Passing character strings to a UDF in a different character set

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