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

[Brett Nemeroff]

Calvin,
The issue is more about what you want to do with that data in the opensips
script. Are you really wanting to do floating point math in the script? Or
are you taking those floats (like GPS coordinates) and using them as string
values in a header. If that’s all you want to do, you should cast your
values as strings before they land in the AVP IMO. No need to support that
floating point format if you arn’t looking to do real-time precision math
IN the script.

If possible, that math really should occur in the database. Easy enough to
do in a avp_db_query.

On Wed, Mar 11, 2020 at 11:57 AM Calvin Ellison <calvin.ellison at voxox.com>
wrote:

>
> 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.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200311/0a3e48e4/attachment.html>