Re: [PATCH] include destination into dlr lookup

Nicholas Rahn <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
I just had a chance to look at this code and i don't think this will
work for swiss or french numbers.  in switzerland there are 10 numbers
in a national number (i.e. "0761234567").  If this is what we receive
from the SMSC, the patch will strip it down to 7 numbers ("1234567"). 
the last 7 characters are not enough to guarantee unicity. Only the
first 3 characters (of the 10) are what determine the operator network
in switzerland and thus we could have 2 stripped numbers that are the
same (ex. 0761234567 and 0791234567 would both strip to 1234567).

back in april i suggested the following solution:

Remove any "00", "0" or "+" prefix from the destination and use this in
a like clause in dlr_find.

this is very similar to the current patch (still requires the LIKE
clause, but i'm not too concerned about that).  and it would solve the
problem mentioned above, making the patch usable for more people.

any thoughts?
nick


On Tue, 2004-09-28 at 13:39, Enver ALTIN wrote:
> Hi,
> 
> On Tue, 2004-09-28 at 13:37 +0200, Alexander Malysh wrote:
> > I don't like the idea of bloating the db and we will not win too much
> > performance (IMHO)... (we should really make benchmarks with
> > direct/indirect db lookup)
> 
> I'm fine either way, as long as it works :)
> 
> Thanks,
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.