| 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-0600 | Date Closed: | 2006-01-09 12:47:39.000-0600 |
| Priority: | Minor | Regression? | No |
| Status: | Closed/Complete | Components: | Applications/app_voicemail |
| Versions: | Frequency of Occurrence | ||
| Related Issues: | |||
| Environment: | Attachments: | ||
| 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. | ||