[Asterisk-Dev] storage binary data through RealTime interface

[Matthew Boehm]

If you have a better way to allow 2 or more Asterisk boxes to share the same
voicemail files I'm sure others would be happy to hear.

-Matthew

Quoting "Nathan C. Smith" <smith at ipmvs.com>:

>
> It is usually considered inefficient to store blob data in the database, but
> there are ways it can be done.  You pay a penalty both when you insert it
> and extract it.  Are you committed to doing it that way?
>
> -Nate
>
> -----Original Message-----
> From: Timur V. Elzhov [mailto:Timur.Elzhov at jinr.ru]
> Sent: Tuesday, August 02, 2005 8:36 AM
> To: asterisk-dev at lists.digium.com
> Subject: [Asterisk-Dev] storage binary data through RealTime interface
>
>
>
> Dear experts,
>
> I'd like to implement voicemail storage to DB through RealTime interface. I
> succeded to store all the information *about* incoming voice message, but
> I've been stuck with storage of voice message (blob data) itself. I had a
> glance at the ODBC and MySQL driver codes and found that with SQL tamplate
> which is hardcoded in drivers (say, in res_config_mysql.c),
>
> "SELECT * FROM %s WHERE %s%s '%s'", table, newparam, op, newval
>
> It seems to be not possible for one to build the correct SQL query with this
> template, because the problem would take place with reading of '\0' symbol,
> apart from wrong query if bytes with ASCII code "\'" will be included in the
> value.
>
> So, how the database binary (in/out)put is planned to be supported in
> RealTime?
>
>
> --
> Best regards,
> Timur Elzhov
>
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-dev
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-dev
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.