Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Leyne, Sean
> As far as I understand it is specifically for backwards compatibility (eg > tools > that expect/depend on the max 31 characters **and** max 31 > bytes) limit OK, that's a reasonable answer. But does that mean that it needs to be configurable? It would seem that the better answer would be "D

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dmitry Yemanov
12.01.2017 18:00, Mark Rotteveel wrote: > > As far as I understand it is specifically for backwards compatibility > (eg tools that expect/depend on the max 31 characters **and** max 31 > bytes) limit Then IMO it should be a boolean, not a numeric limit. Dmitry -

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dmitry Yemanov
12.01.2017 17:33, Leyne, Sean wrote: > > Why is a configuration setting for this required? > > This seems like a fix/complication for a problem that doesn't really exist. That was my opinion too. Dmitry -- Developer Ac

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Mark Rotteveel
On 12-1-2017 15:57, Jiří Činčura wrote: >> Maximum is 63 characters. IIRC, configuration allows to lower this limit. > > What would be the scenario for lowering this limit? Does it make sense > to have configurable? > As far as I understand it is specifically for backwards compatibility (eg tools

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Jiří Činčura
> Maximum is 63 characters. IIRC, configuration allows to lower this limit. What would be the scenario for lowering this limit? Does it make sense to have configurable? -- Mgr. Jiří Činčura Independent IT Specialist --

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Leyne, Sean
> > Is there a maximum length, or can I theoretically use a length of say > > 8191 characters for an identifier? > > Maximum is 63 characters. IIRC, configuration allows to lower this limit. Why is a configuration setting for this required? This seems like a fix/complication for a problem that

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Mark Rotteveel
On 12-1-2017 13:38, Dmitry Yemanov wrote: > 06.01.2017 17:53, Mark Rotteveel wrote: > >> I just noticed that in Firebird 4 the identifier length limits are >> configurable. >> >> Is there a maximum length, or can I theoretically use a length of say >> 8191 characters for an identifier? > > Maximum

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dmitry Yemanov
06.01.2017 17:53, Mark Rotteveel wrote: > I just noticed that in Firebird 4 the identifier length limits are > configurable. > > Is there a maximum length, or can I theoretically use a length of say > 8191 characters for an identifier? Maximum is 63 characters. IIRC, configuration allows to lower

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dimitry Sibiryakov
12.01.2017 13:27, Mark Rotteveel wrote: >> I just noticed that in Firebird 4 the identifier length limits are >> configurable. >> >> Is there a maximum length, or can I theoretically use a length of say >> 8191 characters for an identifier? >> >> Is there a quick and easy way to determine the maxim

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Mark Rotteveel
On 6-1-2017 15:53, Mark Rotteveel wrote: > I just noticed that in Firebird 4 the identifier length limits are > configurable. > > Is there a maximum length, or can I theoretically use a length of say > 8191 characters for an identifier? > > Is there a quick and easy way to determine the maximum ide

[Firebird-devel] Firebird 4 identifier limits

2017-01-06 Thread Mark Rotteveel
I just noticed that in Firebird 4 the identifier length limits are configurable. Is there a maximum length, or can I theoretically use a length of say 8191 characters for an identifier? Is there a quick and easy way to determine the maximum identifier length of a database (eg a service call)?