[asterisk-users] Error: 'LENGTH' is not a recognized built-in function name
deepaksingh.rawat at gmail.com
Mon Aug 11 00:19:33 CDT 2014
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 <b.lavallee at globaltank.jp>
> On 8/11/14, 11:31, Matthew Jordan wrote:
>> On Sun, Aug 10, 2014 at 5:02 PM, Deepak Rawat
>> <deepaksingh.rawat at gmail.com> wrote:
>>> On Mon, Aug 11, 2014 at 3:29 AM, Deepak Rawat <
>>> deepaksingh.rawat at gmail.com>
>>>> 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)
> RETURN ( LEN(@input) )
>> 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
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the asterisk-users