meta data for this page
  •  

F_STRINGLENGTH(F_STRINGLENGTH4, F_STRINGLENGTH8, F_STRINGLENGTH32), F_BIGSTRINGLENGTH

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

input/output-compatibility to rFunc (STRLEN)

Entrypoint stringlength not compatible with UTF-8 - use U_STRINGLENGTH

U_STRINGLENGTH(U_STRINGLENGTH4, U_STRINGLENGTH8, U_STRINGLENGTH32)

function from adhoc

Entrypoint u_stringlength compatible with UTF-8

Inputs/Outputs

   Input        CSTRING(32760)        String
   Output       INTEGER               Determines the length of a string, considers also simple blanks at the end

Syntax

   F_STRINGLENGTH and F_BIGSTRINGLENGTH are not allowed in one SQL.
   TestSQL
   SELECT 17 AS ISCORRECT, F_STRINGLENGTH('Dies ist ein Test') FROM RDB$DATABASE;
   SELECT 19 AS ISCORRECT, F_STRINGLENGTH('Dies ist ein Test  ') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRINGLENGTH(NULL) FROM RDB$DATABASE;