[OpenSIPS-Users] phonenumber format into mysql database

Bogdan-Andrei Iancu bogdan at opensips.org
Mon Feb 4 03:05:39 EST 2019


Hi Mickael,

My turn :) . In drouting, the data is stored in memory as a decimal 
tree, so only digits are allowed. It is a constraint coming from how the 
search tree is structured.

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
OpenSIPS Summit 2019
   https://www.opensips.org/events/Summit-2019Amsterdam/

On 01/27/2019 08:51 AM, Mickael Hubert wrote:
> Hi
> I'm sorry for my late answer. I'm talking about drouting table for 
> example.
>
>
> Le mer. 3 oct. 2018 22:14, Bogdan-Andrei Iancu <bogdan at opensips.org 
> <mailto:bogdan at opensips.org>> a écrit :
>
>     Hi Mickael,
>
>     AFAIK E164 is without '+' (which is actually a breakout code, not
>     part of the number itself).
>
>     And when you say the numbers are stored in DB - which module/table
>     are you talking about ?
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>
>     OpenSIPS Founder and Developer
>        http://www.opensips-solutions.com
>     OpenSIPS Bootcamp 2018
>        http://opensips.org/training/OpenSIPS_Bootcamp_2018/
>
>     On 10/03/2018 11:47 AM, Mickael Hubert wrote:
>>     Hi all,
>>     I have a non technical question.
>>     why phonenumbers into database are stocked whitout + sign (non
>>     E164 format) ?
>>     is it for a prformance purposes ?
>>
>>     I'm looking for the best way to store E164 phonenumbers for a
>>     personnal dev.
>>
>>     thanks in advance
>>
>>     ++
>>     Micka
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190204/de1c5427/attachment.html>


More information about the Users mailing list