VoIP Mailing List Archives :: View topic - [asterisk-users] Voicemail ODBC Storage

Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community

[asterisk-users] Voicemail ODBC Storage

VoIP Mailing List Archives Forum Index -> Asterisk Users

View previous topic :: View next topic

Author

Message

dan at keshercommunica...
Guest

Posted: Sat Oct 25, 2014 4:10 pm Post subject: [asterisk-users] 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 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users

mjordan at digium.com
Guest

Posted: Sat Oct 25, 2014 8:52 pm Post subject: [asterisk-users] Voicemail ODBC Storage

On Sat, Oct 25, 2014 at 4:09 PM, Dan Journo <dan@keshercommunications.com (dan@keshercommunications.com)> wrote:

Quote:

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

amessina at messinet.com
Guest

Posted: Sun Oct 26, 2014 7:27 am Post subject: [asterisk-users] Voicemail ODBC Storage

On Saturday, October 25, 2014 09:09:57 PM Dan Journo wrote:

Quote:

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

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users

Display posts from previous:

	VoIP Mailing List Archives Forum Index -> Asterisk Users	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum