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