Oh Ok. Got it. Thanks for the inputs. --- Jayesh
On Wed, Mar 13, 2013 at 8:26 AM, Ovidiu Sas <[email protected]> wrote: > Make sure that the values are stored as strings in the table, not as float. > > -ovidiu > > On Tue, Mar 12, 2013 at 10:40 PM, Jayesh Nambiar <[email protected]> > wrote: > > Hi Ovidiu, > > Thanks for your reply. But I just expect them to be stored as string in > my > > AVPs. Even in 1.8.2, when I dumped those AVPs back into a database > table, it > > always put the exact value like 1.0000 or 0.0123 etc. So it was indeed > > storing the entire value as string in the AVPs and not as 1 or 0. Is this > > behaviour changed now? > > > > > > --- Jayesh > > > > > > On Tuesday, March 12, 2013, Ovidiu Sas wrote: > >> > >> You are trying to store a float into an int. Prior to 1.9, there > >> wasn't a strict check on the conversion and whatever the result was, > >> it was stored (i.e. 1.000 was stored as 1 and 0.0123 was stored as 0). > >> For more info: http://linux.die.net/man/3/strtol > >> Starting with 1.9, there is a strict check for invalid characters and > >> therefore the conversion fails: 1.000 and 0.0123 are not a valid > >> integers. > >> > >> Regards, > >> Ovidiu Sas > >> > >> On Tue, Mar 12, 2013 at 10:36 AM, Jayesh Nambiar <[email protected]> > >> wrote: > >> > Hi, > >> > I am testing out Opensips-1.9 currently. While I was using > >> > opensips-1.8.2, I > >> > used avp_db_query to query some values from database tables which were > >> > float > >> > point values and used those values to insert into acc table. Obviously > >> > for > >> > billing reasons. But after upgrading to 1.9 it gives error. > >> > Eg: I am querying a table containing values 1.0000, 0.0123 etc. and > >> > storing > >> > it into AVPs. But the 1.9 version gives the following error: > >> > ERROR:core:db_str2int: Unexpected characters: [.0000] > >> > ERROR:db_mysql:db_mysql_str2val: error while converting integer value > >> > from > >> > string > >> > > >> > Can someone help me to take corrective actions inorder to avoid these > >> > errors. Any help is much appreciated. > >> > > >> > Thanks, > >> > > >> > --- Jayesh > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
