Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

BLOB to String

 
Roshan Rama
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

Is it possible for someone to help me convert a BLOB to a String or readable text?
i am recieving this data from a queue.

Thanks in advance
 
Samuel Behrman
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Direct conversion is not possible without using some UDF, but you can extract text using SUBSTRING function:

DECLARE VARIABLE c1 VARCHAR(32000);
SELECT SUBSTRING(blob1 FROM 1 FOR 32000) FROM t1 INTO c1;

Please note that maximum length for VARCHAR is 32767 bytes (which might be less characters in multi-byte character sets like UTF8).

Various database access layers also have ability to retrieve BLOB data as string. For example, in PHP you could use:

$row = ibase_fetch_assoc($qry, IBASE_TEXT);

This automatically converts all textual BLOBs to VARCHARs, so you don't need to fetch blobs writing specific PHP code.
 
Rob Spoor
Sheriff
Pie
Posts: 20751
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A BLOB (binary large object) is binary data, so it could lead to problems when you convert it to text. If it should always be text a CLOB (character large object) is a better choice.
 
Campbell Ritchie
Sheriff
Posts: 51407
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like something database-related, so I shall move it to our databases forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic