[firebird-support] Converting BLOB to long VARCHAR

2011-12-28 Thread Josef Kokeš
Hi! I am trying to convert a BLOB (unlimited size, theoretically) to a long VARCHAR (say, VARCHAR(8192)). This should be easy enough to do: DECLARE VARIABLE b BLOB; /* input */ DECLARE VARIABLE v VARCHAR(8192); /* output */ ... v = SUBSTRING(b, 1, 8192); Except that as soon as I convert

Re: [firebird-support] Converting BLOB to long VARCHAR

2011-12-28 Thread Milan Babuskov
Josef Kokeš wrote: I am trying to convert a BLOB (unlimited size, theoretically) to a long VARCHAR (say, VARCHAR(8192)). This should be easy enough to do: DECLARE VARIABLE b BLOB; /* input */ Which subtype of BLOB? IIRC, BLOB subtype 1 (text) should support character sets, so you don't

Re: [firebird-support] Converting BLOB to long VARCHAR

2011-12-28 Thread Josef Kokeš
Dne 28.12.2011 17:21, Milan Babuskov napsal(a): Josef Kokeš wrote: I am trying to convert a BLOB (unlimited size, theoretically) to a long VARCHAR (say, VARCHAR(8192)). This should be easy enough to do: DECLARE VARIABLE b BLOB; /* input */ Which subtype of BLOB? IIRC, BLOB subtype 1 (text)