Voicemail ODBC Storage

Home » Asterisk Users » Voicemail ODBC Storage
Asterisk Users 2 Comments

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

2 thoughts on - Voicemail ODBC Storage

  • 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.