[Kamailio-Users] [Re: Re: BIGINT in avp]

[Daniel-Constantin Mierla]

On 03/24/2009 12:13 PM, kokoska rokoska wrote:
> Daniel-Constantin Mierla napsal(a):
>   
>> Hello,
>>
>> On 03/21/2009 11:30 AM, kokoska.rokoska wrote:
>>     
>>> Hi all,
>>>
>>> I have small (and may be stupid) question:
>>>
>>> could I store BIGNT from MySQL DB into avp using avp_db_query? And if
>>> yes, how?
>>>   
>>>       
>> no, avps can hold only string or integer values.
>>     
>
> Thank you very much, Daniel, for your answer!
>
>  Maybe you can get what
>   
>> you want via string - keep the bigint as string. Probably in the future
>> will take this in consideration.
>>
>>     
>
> I'm affraid I can't do that, 'cause it is primamy key and there are a
> lot of foreign keys linked to it. And due to performance loss I worry
> about to change all of them to strings...
> May be I should "cast" them (by SELECT) to strings.
>   

this is the option I though about -- keep the bigint as string in avp.

Cheers,
Daniel

>   
>> Now the focus is to integrate http://sip-router.org -- several modules
>> left there and then we can take new features request on board:
>> http://sip-router.org/wiki/devel/kamailio-integration#module_integration_status
>>
>>     

-- 
Daniel-Constantin Mierla
SIP Router Masterclass - Kamailio (OpenSER) Training
http://www.asipto.com/index.php/sip-router-masterclass/