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

Jay R. Ashworth jra at baylink.com
Fri May 23 09:25:21 CDT 2008

On Thu, May 22, 2008 at 04:52:02PM -0500, Tilghman Lesher wrote:
> > The ',' used inside of a database field is not a real problem for the
> > database once it's there, the issue arises during import/export
> > operations to and from the database.  This has a great potential to
> > screw up the database, one bad csv import and all hell breaks loose.
> Yes, well, that hasn't changed.  You could screw up the import before, and
> you can still screw it up.  

Actually, no, that's a handwave.  "," is a fairly common character in
live data fields in databases.  "|", on the other hand, is not; it's an
ASCII character, but it's not an English character.

Additionally, *because* commas are live data, we've gone to "commas and
quotes", of which I gather there are something like 17 different
implementations and sets of semantics.  So, no, comma is *never* a good
technical delimiter.  Ever.  Really.  We're not just making it up.

-- 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)

More information about the asterisk-dev mailing list