Subject | FireBird 2.5 Varchar problem |
---|---|
Author | Hans |
Post date | 2010-10-29T23:24:13Z |
Hi Folks,
In a procedure I'm trying to put some kind of report together using
Declare Variable Report Varchar(31000)
starting out with Report = ''; and appending pieces of information
to the variable Report using either
Report = Report || 'Some Text';
or
Report = Report || Some.Variable
It keeps on failing when the Char_Length(Report) exceeds
around 1072 to 1100 characters.
Any idea what the reason could be, I thought I should be
able to continue till at least a maximum char_length of about (31000 div 4)
under FB2.5
Best Regards
Hans
In a procedure I'm trying to put some kind of report together using
Declare Variable Report Varchar(31000)
starting out with Report = ''; and appending pieces of information
to the variable Report using either
Report = Report || 'Some Text';
or
Report = Report || Some.Variable
It keeps on failing when the Char_Length(Report) exceeds
around 1072 to 1100 characters.
Any idea what the reason could be, I thought I should be
able to continue till at least a maximum char_length of about (31000 div 4)
under FB2.5
Best Regards
Hans