[asterisk-users] Error: 'LENGTH' is not a recognized built-in function name

[Deepak Rawat]

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>
wrote:

>
> 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>
>>> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140811/261e0a13/attachment.html>