Summary:ASTERISK-06023: data type for 'recording' parameter should be SQL_LONGVARBINARY, not SQL_BINARY
Reporter:Vadim Berezniker (kryptolus)Labels:
Date Opened:2006-01-09 11:31:26.000-0600Date Closed:2006-01-09 12:47:39.000-0600
Versions:Frequency of
Description:At around line 1244 of app_voicemail.c where the 'recording' parameter is bound, its type should be SQL_LONGVARBINARY and not SQL_BINARY. Using SQL_BINARY fails when running against MSSQL. According to http://dev.mysql.com/doc/refman/5.0/en/myodbc-data-types.html, the proper type for mysql should be SQL_LONGVARBINARY as well. I guess mysql doesn't really care so it accepts SQL_BINARY as well, but MSSQL is a bit more pickier.

This affects 1.2.1, but I looked at the trunk and it seems to be the same there.
Comments:By: Jason Parker (jparker) 2006-01-09 11:40:32.000-0600

This is related to part of ASTERISK-5903.  I think we should close this, and move the discussion there.