[asterisk-dev] Asterisk 1.6 Realtime Database must use ', ' not '|' in appdata field?

[Jay R. Ashworth]

On Thu, May 22, 2008 at 01:17:54PM -0500, Tilghman Lesher wrote:
> On Thursday 22 May 2008 12:51:36 JR Richardson wrote:
> > I'm testing 1.6 ARA.  All seems to be functioning well, but Asterisk
> > does not like | (pipe) separators in the appdata fields in the
> > database.  I don't think this is particular to ARA because I see the
> > same results when I use static extensions in extensions.conf also.
> >
> > So I'm guessing pipe processing has been deprecated or possibly this is a
> > bug?
> 
> Removed.  Comma is what most people are used to using in extensions.conf,
> and has thus been made the authoritative delimiter.
> 
> > The problem is that 1.2 (which i still use in production) behavior
> > requires a | for the separator in the appdata fields for ARA database
> > operation due to ',' being a end of field indication for the database
> 
> I don't understand this.  Character type fields are all enclosed in quotes,
> and commas are fine embedded in fields.

Commas are miserable field delimiters, my 20 years of database
programming experience teaches me.  Tabs, or if you must see the
characters, pipes, are the best choice.  Why was the capability
removed?

Cheers,
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274

	     Those who cast the vote decide nothing.
	     Those who count the vote decide everything.
	       -- (Joseph Stalin)