asterisk users - Oct 2014 - Voicemail ODBC Storage

Hi, 

Is there any reason why ODBC voicemail storage requires varchar for most fields?
For example, is there anything stopping me using a BIGINT or similar for
origtime or INT for duration?

Kind regards,
Dan

On Sat, Oct 25, 2014 at 4:09 PM, Dan Journo <dan at
keshercommunications.com>
wrote:
> Hi,
>
> Is there any reason why ODBC voicemail storage requires varchar for most
> fields?
> For example, is there anything stopping me using a BIGINT or similar for
> origtime or INT for duration?
>
>
Yes.

app_voicemail uses a message envelope file to hold the metadata regarding
the voice mail. When the ODBC retrieve function pulls the database records,
it writes that data out to a temporary message envelope file for
playback/manipulation by other functions. This process does not examine the
column types, but instead simply looks at the column names and writes the
data values out to the file using the types that it expects each column
name to have.

So, changing those types will not work out well for you.

-- 
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20141025/28b7c0ad/attachment.html>

On Saturday, October 25, 2014 09:09:57 PM Dan Journo
wrote:
> Is there any reason why ODBC voicemail storage requires varchar for most
> fields?  For example, is there anything stopping me using a BIGINT or
> similar for origtime or INT for duration?
It may cause you trouble when using PostgreSQL: 
https://issues.asterisk.org/jira/browse/ASTERISK-24441

-A

-- 
Anthony - https://messinet.com/ - https://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: This is a digitally signed message part.
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20141026/2a7402b7/attachment.pgp>