|Subject||Re: [firebird-support] Re: REPLACE() Retaining EOF marker from BLOB|
On 7-8-2012 20:34, red_october2009 wrote:
> Solution found: Just chop off the last character from the BLOB to be inserted, before doing the REPLACE()What is your Firebird version? As you describe it, it sounds like a bug.
> vCHT_TXT = SUBSTRING(:vCHT_TXT FROM 1 FOR CHAR_LENGTH(vCHT_TXT) - 1);
> ... Then do your REPLACE()