meta data for this page
  •  

F_BLOBASPCHAR

compatibility to FreeUDFLib, FreeUDFLib AvERP, GrUDF

Entrypoint blobaspchar not compatible with UTF-8 - use BLOB like a string

Inputs/Outputs

   Input      BLOB               TextBlob to convert to VarChar
   Output     CSTRING(32760)     String

Syntax

   TestSQL (to use with TestISO.GDB)
   SELECT 'ein einzeiliger TextBLOb' AS ISCORRECT, TEXTBLOB, F_BLOBASPCHAR(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 1;
   SELECT '' AS ISCORRECT, F_BLOBASPCHAR(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 11;
   SELECT NULL AS ISCORRECT, F_BLOBASPCHAR(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 10;