[firebird-support] string right truncation error with LIKE predicate and UTF8 DB

2019-07-15 Thread Rustam rusta...@ukr.net [firebird-support]
Video demonstration of bug in our discussion: http://dl.free.fr/inU3HYrcm http://zalil.su/3558776

Re: [firebird-support] string right truncation error with LIKE predicate and UTF8 DB

2017-11-02 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Friday, November 3, 2017, 3:12:37 AM, Rustam wrote: > I got an error executing SELECT query with LIKE predicate in case of UTF8 > database, > non-UTF8 connection charset and national characters in LIKE > argument without mask symbols '%' and '_' > Error is > "arithmetic exception, numeric overf

[firebird-support] string right truncation error with LIKE predicate and UTF8 DB

2017-11-02 Thread Рустам Муса-Ахунов rusta...@ukr.net [firebird-support]
Hi, people! I know, that same bugs was discussed early in bug tracker, although bug not fixed, I think they not the same. I got an error executing SELECT query with LIKE predicate in case of UTF8 database,  non-UTF8 connection charset and national characters in LIKE argument without mask

Re: [firebird-support] String right truncation Error

2012-02-27 Thread Aldo Caruso
Mark, Thank you very much for your advice and support ! The bug described in CORE-3211 is exactly the one I found and it was resolved in version 2.5.1 On the other hand I will try to get in touch with the package maintainer in Debian 6.0 in order to ask him to upload the 2.5.1 versio

Re: [firebird-support] String right truncation Error

2012-02-27 Thread Ismael L. Donis Garcia
-support] String right truncation Error I'm running Firebird 2.5.0 on Linux Debian 64 bits Sever version: LI-V2.5.0.26054 Firebird 2.5 Release Candidate 3 Aldo El 25/02/12 13:25, Mark Rotteveel escribió: > > On 25-2-2012 16:26, Aldo Caruso wrote: > > I did th

Re: [firebird-support] String right truncation Error

2012-02-26 Thread Mark Rotteveel
On 25-2-2012 20:11, Aldo Caruso wrote: > Mark, > > I really don't know why, in the Debian stable version, the Firebird > SS package isn't the final one but a Release Candidate. > On the other hand, your advice worked fine, although I don't figure > why. > In this context, an EXIST

Re: [firebird-support] String right truncation Error

2012-02-25 Thread Aldo Caruso
Mark, I really don't know why, in the Debian stable version, the Firebird SS package isn't the final one but a Release Candidate. On the other hand, your advice worked fine, although I don't figure why. In this context, an EXIST clause is more efficient than a IN clause, but both

Re: [firebird-support] String right truncation Error

2012-02-25 Thread Mark Rotteveel
On 25-2-2012 18:48, Aldo Caruso wrote: > I'm running Firebird 2.5.0 on Linux Debian 64 bits > Sever version: > LI-V2.5.0.26054 Firebird 2.5 Release Candidate 3 You are not even running 2.5.0 final, but RC3. You either need to upgrade to 2.5.1 or rewrite your view not to use IN (SELECT ) but

Re: [firebird-support] String right truncation Error

2012-02-25 Thread Aldo Caruso
I'm running Firebird 2.5.0 on Linux Debian 64 bits Sever version: LI-V2.5.0.26054 Firebird 2.5 Release Candidate 3 Aldo El 25/02/12 13:25, Mark Rotteveel escribió: > > On 25-2-2012 16:26, Aldo Caruso wrote: > > I did the three tests you mention and the error persists in Firebird 2.5 > > ( and it

Re: [firebird-support] String right truncation Error

2012-02-25 Thread Mark Rotteveel
On 25-2-2012 16:26, Aldo Caruso wrote: > I did the three tests you mention and the error persists in Firebird 2.5 > ( and it does not exists neither in 2.0 version nor in 2.1 version ) > More, I recreated the error with brand new tables and view, so anybody > can recreate it and verify. It works f

Re: [firebird-support] String right truncation Error

2012-02-25 Thread Aldo Caruso
I did the three tests you mention and the error persists in Firebird 2.5 ( and it does not exists neither in 2.0 version nor in 2.1 version ) More, I recreated the error with brand new tables and view, so anybody can recreate it and verify. CREATE TABLE TABLE_1 ( ID INTEGER NOT NULL ); ALT

Re: [firebird-support] String right truncation Error

2012-02-25 Thread Mark Rotteveel
On 24-2-2012 20:16, Aldo Caruso wrote: > I migrated from Firebird 2.0 to 2.5 > The databas has a VIEW wich basically selects two fields: CODIGO ( > Integer ) and NOMBRE (Varchar 50 ) from a table. > When in Firebird 2.0 there was no problem running SELECT * FROM > > Now, in

[firebird-support] String right truncation Error

2012-02-24 Thread Aldo Caruso
Hi, I migrated from Firebird 2.0 to 2.5 The databas has a VIEW wich basically selects two fields: CODIGO ( Integer ) and NOMBRE (Varchar 50 ) from a table. When in Firebird 2.0 there was no problem running SELECT * FROM Now, in Firebird 2.5 I got the following error message: