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
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
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)