Subject Re: Basic udf question
Author Adam
--- In, "x2412421" <x2412421@...> wrote:
> Hi,
> If in my database I declare some standard udf that come with Firebird
> (for example the udf named "lower") is it sure that it will work on
> all platforms such as Windows and Linux or I will also have something
> to do on the server side ?

UDFs are functions that the database engine calls. On Windows, they
are .dll files, on Linux they are .so files. Providing the udf library
is called the same thing, and the user the database engine is running
as has appropriate permissions, it will work cross platform.

By the way, are you aware that you can use UPPER without the need for
a UDF declaration? If you are using lower for case insensitive
matching or sorting, then you also have collations to make use of.