[sr-dev] storing DOUBLE in mysql

[Daniel-Constantin Mierla]

Hello,

On 2/10/10 5:08 PM, Aymeric Moizard wrote:
>
> Hi,
>
> I'm using kamailio release 3.0 (from git branch3 of sip router)
> and I'm trying to store a double value in my mysql database:
>
> I discovered that existing code only allow 2 decimal digit precision
> in file "db_ut.c":
>
> ret = snprintf(_s, *_l, "%-10.2f", _v);
>
> I don't clearly understand the reason,

the pseudo-variables have support only for integer or string values (no 
doubles in cfg operations).

Double is used internally only for contact q value, and I guess that has 
2 digits precision. It is fine for me to increase the precision. I 
cannot think now of any drawback.

Cheers,
Daniel

> but would like to
> know if you wouldn't mind extending it? I would need 7 digits.
>
> Regards,
> Aymeric MOIZARD / ANTISIP
> amsip - http://www.antisip.com
> osip2 - http://www.osip.org
> eXosip2 - http://savannah.nongnu.org/projects/exosip/
>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>

-- 
Daniel-Constantin Mierla
eLearning class for Kamailio 3.0.0
* http://www.asipto.com/