Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-03 Thread Thomas Steinmaurer
>>> RELATION_NAME >>> = >>> Statement failed, SQLSTATE = 22001 >>> arithmetic exception, numeric overflow, or string truncation >>> -string right truncation >>> -expected length 10, actual 21 >>> SQL> >> Seems to be a problem with using the TYPE OF clause for the data type. >> When I re

Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-03 Thread Alex Peshkoff
On 10/03/14 01:25, Thomas Steinmaurer wrote: >> RELATION_NAME >> = >> Statement failed, SQLSTATE = 22001 >> arithmetic exception, numeric overflow, or string truncation >> -string right truncation >> -expected length 10, actual 21 >> SQL> > Seems to be a problem with using the TYPE OF

Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-02 Thread Thomas Steinmaurer
Hello, > I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. > > In a UTF8 database, I have a table with the following name: > > A_VERY_LONG_TABLENAME > > > And a package with a single selectable SP, basically querying the table > names: > > SET TERM ^^ ; > CREATE OR ALTER P

[Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-02 Thread Thomas Steinmaurer
Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. In a UTF8 database, I have a table with the following name: A_VERY_LONG_TABLENAME And a package with a single selectable SP, basically querying the table names: SET TERM ^^ ; CREATE OR ALTER PACKAGE PKG_SCHEMA_