Firebird Documentation IndexFirebird 2.0.6 Release NotesNew in Firebird 2.0 → UDFs Improved re NULL Handling
Firebird Home Firebird Home Prev: Additional Database Shutdown Modes IntroducedFirebird Documentation IndexUp: New in Firebird 2.0Next: Run-time Checking for Concatenation Overflow

UDFs Improved re NULL Handling

C. Valderrama

Signalling SQL NULL

Signalling SQL NULL

  • Ability to signal SQL NULL via a NULL pointer (see Signal SQL NULL in UDFs).

  • External function library ib_udf upgraded to allow the string functions ASCII_CHAR, LOWER, LPAD, LTRIM, RPAD, RTIM, SUBSTR and SUBSTRLEN to return NULL and have it interpreted correctly.

    The script ib_udf_upgrade.sql can be applied to pre-v.2 databases that have these functions declared, to upgrade them to work with the upgraded library. This script should be used only when you are using the new ib_udf library with Firebird v2 and operation requests are modified to anticipate nulls.

Prev: Additional Database Shutdown Modes IntroducedFirebird Documentation IndexUp: New in Firebird 2.0Next: Run-time Checking for Concatenation Overflow
Firebird Documentation IndexFirebird 2.0.6 Release NotesNew in Firebird 2.0 → UDFs Improved re NULL Handling