Em 06/01/2016 12:32, Simonov Denis escreveu: > Gabor Boros <gaborbo...@yahoo.com> wrote Wed, 06 Jan 2016 12:32:31 +0300: > >> Hi All, >> >> After switched from 3.0.0.32233 to 32266 my app (and IBExpert) give a >> string error with the below query, "expected length 124, actual 0". >> >> SELECT COUNT(MON$ATTACHMENTS.MON$ATTACHMENT_ID) FROM MON$ATTACHMENTS >> WHERE (MON$SYSTEM_FLAG=0) AND (UPPER(:UN)=MON$USER) >> >> I set :UN to 'A' got 0, 'AA' got 0, ... 'AAAA' got 1, 'AAAAA' got 1, >> 'AAAAAAAA' got 2, ... >> >> Something changed in the server and the client apps need follow the >> change or is it a bug? >> >> Gabor >> > > Agree. I error occurs only when the database in UTF-8. > I suspect that this is due here this correction > http://sourceforge.net/p/firebird/code/62766. >
Should be fixed with the committed change now. No code will ever work correctly with multibyte character sets and CHAR (SQL_TEXT) descriptors. People should understand that. Please stop using it. If Firebird describes columns as SQL_TEXT, change it to SQL_VARYING. Adriano ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
