Hi Guys, Wonder if anyone has experienced this before, on kamailio 4.1. I am using an sql_pvquery and it works fine, unless I pull a value from the database that is defined as 10 digits and starts with a 3, actually its populated as 03785702370 but due to the table it removes the leading 0 (bigint(20) unsigned). Running a manual query in my database for a DestinationMsisdn I get;
select DestinationMsisdn,SourceMsisdn from MsisdnPoolAllocations where PoolMsisdn='+44162489xxxx';+-------------------+--------------+| DestinationMsisdn | SourceMsisdn |+-------------------+--------------+| 3785702370 | 4474526xxxxx |+-------------------+--------------+
However running in the kamailio.cfg an sql_pvquery to do the same query as below; sql_pvquery("cd","select DestinationMsisdn,SourceMsisdn from MsisdnPoolAllocations where PoolMsisdn='$rU'","$var(MOdest),$var(NewSourceMSISDN)"); However this returns a value of -509264926 for $var(MOdest) which should just be the 3785702370 number. What can cause kamailio to interpret this as a negative value? Has anyone seen this before? Many thanks Jon