4D v13.4

BLOB to text

Home

 
4D v13.4
BLOB to text

BLOB to text 


 

BLOB to text ( blob ; textFormat {; offset {; textLength}} ) -> Function result 
Parameter Type   Description
blob  BLOB in BLOB from which to get the text
textFormat  Longint in Format and character set of text
offset  Variable in Offset within the BLOB (expressed in bytes)
in New offset after reading
textLength  Longint in Number of characters to be read
Function result  Text in Text extracted

The BLOB to text command returns a Text value read from the BLOB blob.

The textFormat parameter fixes the internal format and character set of the text value to be read. In databases created beginning with version 11, 4D uses the Unicode character set (UTF8) by default for managing text. For the sake of compatibility, this command can be used to “force” conversion using the Mac Roman character set (used in previous versions of 4D). The character set is chosen via the textFormat parameter. To do this, pass one of the following constants (found in the BLOB theme) in the textFormat parameter:

Constant Type Value
Mac C string Longint 0
Mac Pascal string Longint 1
Mac Text with length Longint 2
Mac Text without length Longint 3
UTF8 C string Longint 4
UTF8 Text with length Longint 5
UTF8 Text without length Longint 6

Notes:

  • The “UTF8” constants can only be used when the application runs in Unicode mode.
  • The “Mac” constants cannot work with texts greater than 32 KB.
  • If you want to work with character sets other than UTF8, use the Convert to text command.

For more information about these constants and the formats they represent, please refer to the description of the TEXT TO BLOB command.

WARNING: The number of characters to be read is determined by the textFormat parameter, EXCEPT for the formats Mac Text without length and UTF8 Text without length, for which you need to specify the number of characters to be read in the textLength parameter. For the other formats, textLength is ignored and you can omit it.

If you specify the optional offset variable parameter, the Text value is read at the offset (starting from zero) within the BLOB. If you do not specify the optional offset variable parameter, the beginning of the BLOB is read according to the value you pass in textFormat. Note that you must pass the offset variable parameter when you are reading text without length.

Note: You should pass an offset value between 0 (zero) and the size of the BLOB minus the size of the text to be read. If you do not do so, the function result is unpredictable.

After the call, the variable is incremented by the number of bytes read. Therefore, you can reuse that same variable with another BLOB reading command to read another value.

 
PROPERTIES 

Product: 4D
Theme: BLOB
Number: 555

 
INDEX

Alphabetical list of commands

 
HISTORY 

Modified: 4D v11 SQL

 
SEE ALSO 

BLOB to integer
BLOB to longint
BLOB to real
Convert to text
INTEGER TO BLOB
LONGINT TO BLOB
REAL TO BLOB
TEXT TO BLOB

 
TAGS 

Text, UTF8***