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
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
