[asterisk-dev] res_config_mysql - maximum field length for appdata

[Tilghman Lesher]

On Friday 07 May 2010 09:58:08 Sebastian Denz wrote:
> Am Freitag, 7. Mai 2010, um 15:29:07 schrieb Tilghman Lesher:
> > On Friday 07 May 2010 04:24:15 Sebastian Denz wrote:
> > > as I am trying to write a complex macro for my users i have the
> > > problem, that the appdata field in the extensions table is to small for
> > > all my macro parameters.
> > >
> > > I am using the DB definition from
> > > http://www.voip-info.org/wiki/view/Asterisk+RealTime+Extensions
> > > so appdata is limited to 128 characters.
> > >
> > > And I would prefer some more ;)
> >
> > Certainly 200 is not a length barrier.  The next limit up really is more
> > along the lines of 4095 characters, which is the size of the variable
> > expansion buffer.  Starting in 1.8, even that limit will be gone, as the
> > variable expansion routines have been modified to use as large buffers as
> > needed (or, in most cases, as small as, which should create a
> > commensurate performance boost).
>
> Thanks you very much for that fast reply!
>
> So I think I can safely alter the appdata row in my extensions table to 512
> characters, without running into problems? :)

The only possible problem I could see would be from your database (constraint
of char/varchar column type being a maximum of 255).

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org