Thanks Jiri, I really appreciate your generous help. Upon further
investigation I found out this is easier to solve on the server side. Below
is the answer, I had to use a cached Google page as the original website was
dead. Hope this helps someone in my particular situation.
Regards,
-Jorge
How to *convert* *BLOB* to *string*?
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).
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
