<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div>Hi Guys,</div><div><br></div><div>Wonder if anyone has experienced this before, on kamailio 4.1.</div><div><br></div><div>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 0<span style="font-size: 12pt;">3785702370 but due to the table it removes the leading 0 (</span>bigint(20) unsigned).</div><div><br></div><div>Running a manual query in my database for a DestinationMsisdn I get;</div><div><br></div><div><br></div><div>select DestinationMsisdn,SourceMsisdn from MsisdnPoolAllocations where PoolMsisdn='+44162489xxxx';</div><div>+-------------------+--------------+</div><div>| DestinationMsisdn | SourceMsisdn |</div><div>+-------------------+--------------+</div><div>| <b>3785702370</b> | 4474526xxxxx |</div><div>+-------------------+--------------+</div><div><br></div><div><br></div><div>However running in the kamailio.cfg an sql_pvquery to do the same query as below;</div><div><br></div><div>sql_pvquery("cd","select DestinationMsisdn,SourceMsisdn from MsisdnPoolAllocations where PoolMsisdn='$rU'","$var(MOdest),$var(NewSourceMSISDN)");</div><div><br></div><div>However this returns a value of <b>-509264926</b> for $var(MOdest) which should just be the <b style="font-size: 12pt;">3785702370</b><span style="font-size: 12pt;"> number.</span></div><div><br></div><div>What can cause kamailio to interpret this as a negative value? Has anyone seen this before?</div><div><br></div><div>Many thanks</div><div><br></div><div>Jon</div> </div></body>
</html>