Correction:



I met to say I then installed FreeAdhocUDF not FreeUDFLib library.



And according to their website I also install the 4 icu*44FAU.dll files to the Bin folder.

http://freeadhocudf.org/documentation_english/dok_eng_icu.html



I’ve rebooted the computer too, so I’m at a loss



Anyone that installed these functions please help if you have any ideas,

Mike



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, August 07, 2015 1:37 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined
Importance: High





Greetings All,



On a new Windows 7 64 bit computer I installed Firebird v2.5.4 64 bit

I then installed the FreeUDFLib 64bit functions



I then did a firebird v1.5.3 backup of the metadata only and then restored this on firebird v2.5.4.

I made sure to use the following switches during the restore

-FIX_FSS_D(ATA) <charset> -- fix malformed UNICODE_FSS data

-FIX_FSS_M(ETADATA) <charset> -- fix malformed UNICODE_FSS metadata



Everything appears to be fine as the restore was successful.



I decide to try to compile a stored procedure that used F_STRINGLENGTH and got the following error:



invalid request BLR at offset 130

function F_STRINGLENGTH is not defined

module name or entrypoint could not be found

Error while parsing procedure DATETIME_TO_STR's BLR



I verified that the function is defined with the following:

select * from rdb$functions where upper(rdb$function_name) = 'F_STRINGLENGTH'



It return one record with the following values:

RDB$FUNCTION_NAME: F_STRINGLENGTH

RDB$FUNCTION_TYPE: 0

RDB$QUERY_NAME: <Empty String>

RDB$DESCRIPTION: <null>

RDB$MODULE_NAME: FreeUDFLib

RDB$ENTRYPOINT: StringLength

RDB$RETURN_ARGUMENT: 0

RDB$SYSTEM_FLAG: 0



What could the issue be?



Thanks,

Mike







[Non-text portions of this message have been removed]