Commented by: @dyemanov

Please show how you declare this function in a database. A complete function body would also be useful.

Commented by: Marco Castro (mcastro)

Dimitry,

One of the problem functions is. I belive that the problem is with functions that are related to strings.

char* EXPORT fn_upper_c (char* s)
{
char *buf;
char *buffer = (char *)MALLOC(strlen(s)+1);
// char *buffer = (char *)MALLOC(512);
char AccentOff[] = {'\0', '\x1', '\x2', '\x3', '\x4', '\x5', '\x6', '\x7', // x0
'\x8', '\x9', '\xa', '\xb', '\xc', '\xd', '\xe', '\xf', // x8
'\x10', '\x11', '\x12', '\x13', '\x14', '\x15', '\x16', '\x17', // x10
'\x18', '\x19', '\x1a', '\x1b', '\x1c', '\x1d', '\x1e', '\x1f', // x18
' ', '!', '"', '#⁠', '$', '%', '&', '\'', // x20
'(', ')', '*', '+', ',', '-', '.', '/', // x28
'0', '1', '2', '3', '4', '5', '6', '7', // x30
'8', '9', ':', ';', '<', '=', '>', '?', // x38
'@', 'A', 'B', 'C', 'D', 'E', 'F', 'G', // x40
'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', // x48
'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', // x50
'X', 'Y', 'Z', '[', '\\', ']', '^', '_', // x58
'`', 'A', 'B', 'C', 'D', 'E', 'F', 'G', // x60
'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', // x68
'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', // x70
'X', 'Y', 'Z', '{', '|', '}', '~', '\x7f', // x78
'E', '\x81', '?', '?', '?', '...', '?', '?', // x80
'?', '?', 'S', '?', '?', '\x8d', 'Z', '\x8f', // x88
'\x90', ''', ''', '"', '"', '?', '-', '?', // x90
'?', '?', 'S', '?', '?', '\x9d', 'Z', 'Y', // x98
'?', '!', '?', '?', '?', '?', '?', '?', // xa0
'?', '?', 'a', '?', '?', '?', '?', '?', // xa8
'?', '?', '?', '?', '\'', '?', '?', '- ', // xb0
'?', '?', 'o', '?', '?', '?', '?', '?', // xb8
'A', 'A', 'A', 'A', 'A', 'A', 'A', 'C', // xc0
'E', 'E', 'E', 'E', 'I', 'I', 'I', 'I', // xc8
'D', 'N', 'O', 'O', 'O', 'O', 'O', '?', // xd0
'?', 'U', 'U', 'U', 'U', 'Y', '?', '?', // xd8
'A', 'A', 'A', 'A', 'A', 'A', 'A', 'C', // xe0
'E', 'E', 'E', 'E', 'I', 'I', 'I', 'I', // xe8
'O', 'N', 'O', 'O', 'O', 'O', 'O', '?', // xf0
'?', 'U', 'U', 'U', 'U', 'Y', '?', 'Y'}; // xf8
short length = 0;

buf = buffer;
length = \(short\)\*s;
s \+= 2;
while \(\*s\)
	\*buf\+\+ = AccentOff\[\*s\+\+\];

\*buf = '\\0';
buffer\[length\] = '\\0';

return buffer;

}

In the database is

DECLARE EXTERNAL FUNCTION MCUPPER
VARCHAR(256) CHARACTER SET WIN1252
RETURNS CSTRING(256) CHARACTER SET WIN1252 FREE_IT
ENTRY_POINT 'fn_upper_c' MODULE_NAME 'mcudflib';

Thanks,

Marco Castro

Commented by: Marco Castro (mcastro)

This is the UDF definitions where you can simulate the problem there, It works with any table with string data,

Commented by: @asfernandes

Your code is bug.
You should use ib_util_malloc from ib_util.dll to alloc memory returned by functions using FREE_IT.