I tried that but for some reason couldn't get it working. My custom function was getting created in dbo and the asterisk kept throwing error. Maybe some mistake on my part. I will try it again.
On Mon, Aug 11, 2014 at 10:44 AM, Brian LaVallee <[email protected]> wrote: > > On 8/11/14, 11:31, Matthew Jordan wrote: > >> On Sun, Aug 10, 2014 at 5:02 PM, Deepak Rawat >> <[email protected]> wrote: >> >>> >>> >>> On Mon, Aug 11, 2014 at 3:29 AM, Deepak Rawat < >>> [email protected]> >>> wrote: >>> >>>> Hi, >>>> >>>> I modified the query in res/res_config_odbc.c. >>>> Original: "SELECT MAX(LENGTH(var_val)) FROM %s WHERE filename='%s'" >>>> Modified: "SELECT MAX(LEN(var_val)) FROM %s WHERE filename='%s'" >>>> >>>> I rebuilt the code and installed Asterisk again. Now static realtime is >>>> working. Should I file a bug report? >>>> >>>> You're more than welcome to; at the same time, the number of people >> using MS SQL Server with Asterisk is not tremendously high - at least >> when compared with the alternatives. Unfortunately, this is one place >> where making things compatible is problematic: MySQL and PostgreSQL >> (which are far more likely to be used with Asterisk) along with Oracle >> use LENGTH, not LEN. >> > > Another option, just add LENGTH as a user-defined function to MS SQL. > > ||-- Something like this...| > CREATE FUNCTION LENGTH (@input) > ||BEGIN > RETURN ( LEN(@input) ) > END| > > > > >> Your solution, as it is currently, wouldn't be acceptable, as it would >> cause far more problems than it would solve. About the only way I >> could see solving this would be to make it configurable some place. >> >> Given the relatively few number of people who use MS SQL Server, I >> wouldn't expect this issue to receive a lot of attention without a >> patch. >> >> > > > > -- > _____________________________________________________________________ > -- 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 >
-- _____________________________________________________________________ -- 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
