[OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

[Calvin Ellison]

Or perhaps a direct way to tell avpops what precision to use for a given
field, as an exported parameter?

double_precision (string)
The number of decimal places to use when converting decimal, floating, and
other double type values to avp string
If no db_id reference number is given, 0 is assumed
double type fields not listed will default to 8 (6?)

this parameter is optional

modparam("avpops","double_precision","[db_id]
field=precision[;field=precision]...")


Then as Brett suggested, "make it [the default precision] defined in the
header file for those who want to recompile it."

What other use cases might there be for double type values? E911 or other
things using GPS coordinates might be stored this way, but 8 digits are
more than enough for that.


Regards,

*Calvin Ellison*
Senior Voice Operations Engineer
calvin.ellison at voxox.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200311/ef8e4cc8/attachment.html>