Subject Re[2]: [firebird-support] Varchar 32765 as result of substring?
Author Björn Reimer
Hi again,
>> Any ideas how I can shorten the result inside a view?

> So, have you tried to create a view and see if in both IBExpert and isql
> the resulting field is reported as VARCHAR(32765)?

I'd expect that the following statement should work.

But it doesn't:

select LPAD('ABC',10,'*'), RPAD('ABC',10,'*')

Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction

(Tested with Firebird 2.1.1, 2.1.2 RC2 and 2.1.2 latest snapshot)

Björn Reimer - RRZE