Hi *,

did I missed something in release notes about this:
SQL> show version;
ISQL Version: WI-V2.1.5.18496 Firebird 2.1
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.1.5.18496
Firebird 2.1"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.1.5.18496
Firebird 2.1/tcp (x2ThinkPad)/P11"
Firebird/x86-64/Windows NT (remote interface), version
"WI-V2.1.5.18496 Firebird 2.1/tcp (x2ThinkPad)/P11"
on disk structure version 11.1
SQL> select CAST(_UTF8'' AS VARCHAR(32765)) from rdb$database where 1=0;
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Data type unknown
-Implementation limit exceeded
-COLUMN DSQL internal
SQL> select CAST(_UTF8'' AS VARCHAR(8191)) from rdb$database where 1=0;
SQL>

SQL> show version;
ISQL Version: WI-V2.5.2.26540 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.2.26540
Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.2.26540
Firebird 2.5/tcp (x2ThinkPad)/P12"
Firebird/x86-64/Windows NT (remote interface), version
"WI-V2.5.2.26540 Firebird 2.5/tcp (x2ThinkPad)/P12"
on disk structure version 11.2
SQL> select CAST(_UTF8'' AS VARCHAR(32765)) from rdb$database where 1=0;
SQL> select CAST(_UTF8'' AS VARCHAR(8191)) from rdb$database where 1=0;
SQL>
?

The VARCHAR(32765) fails on 2.1 and succeeds in 2.5 (and fails on 2.5
with 11.1 ODS, of course). I don't remember reading about such a
change. But as I said, maybe I missed it.

JC

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com