[Asterisk-Users] OT: Best DB

[David Brodbeck]

> -----Original Message-----
> From: Giudice, Salvatore [mailto:Salvatore.Giudice at FMR.COM]

> As for your 'artist license with your data' comment, put it into some
> context. I would blame a programmer for trying to insert a 
> string of 255
> characters into a field only 100 character wide. Maybe you could blame
> the dba for not building a schema to support the application.
> Regardless, I would not call the database deficient because 
> it truncates
> your data to 100 characters and doesn't warn you with an error.

And the sad fact is, if the software isn't doing any data verification, it's
probably not doing error checking either.  So if the DB throws an error,
your database will be protected, but the application will probably crash or
do something undefined.  Which of those situations (truncated data, or a
crashed app) is better depends on the application.  It's not clear cut.