Re: [Firebird-devel] Maximum length of string literals

2015-07-16 Thread Dmitry Yemanov
15.07.2015 19:03, Adriano dos Santos Fernandes wrote: > > Looking again, Ivan Přenosil may be right and string literals up to 64K > byte-length *may* be safe, as descriptors uses USHORT and internal > calculations ULONG. > > At the same time, columns, parameters and everything else should be > cons

Re: [Firebird-devel] Maximum length of string literals

2015-07-15 Thread James Starkey
Why not just go for 32 bit lengths and stop worrying about it. 16 bit lengths made a lot of sense on pdp-11s, but those days are long gone. On Wednesday, July 15, 2015, Adriano dos Santos Fernandes < adrian...@gmail.com> wrote: > Hi! > > Looking again, Ivan Přenosil may be right and string liter

Re: [Firebird-devel] Maximum length of string literals

2015-07-15 Thread Ivan Přenosil
> It works in FB2.5, but does not in FB3beta2 > -String literal with 4 bytes exceeds the maximum length of 32765 bytes actually it shows this strange length -String literal with 40078 bytes exceeds the maximum length of 32765 bytes -

Re: [Firebird-devel] Maximum length of string literals

2015-07-15 Thread Ivan Přenosil
Also try this - 4 characters of binary string should be transformed into valid 2 character string SELECT OCTET_LENGTH(x'1234... 4x ... ') FROM RDB$DATABASE It works in FB2.5, but does not in FB3beta2 -String literal with 4 bytes exceeds the maximum length of 32765 bytes Ivan