thanks On Jan 3, 11:27 am, Sarwar Erfan <erfanonl...@gmail.com> wrote: > Ok... here is the story then... > Phone numbers are stored in stripped reversed order for easier matching. It > helps to use the LIKE operator in SQL. > > For a normal SQL user, it might look same to use *where NUMBER_KEY LIKE > '%1234'* and *where NUMBER_KEY LIKE '4321%'.* > But for the db engine, having the wildcard at the end is much easier > (efficient) Efficiency is a major factor for incoming call caller id lookup. > > BTW, you might have not noticed, most phones (not talking about android > only) does not match the whole number for caller id lookup. > In all my Nokia phones I have a number saved, say its 016 12345678 (its not > the real number) as Mr X > When I get phone call from another number 016 99345678, it shows Mr X is > calling. It compares only last few digits!!! > > Regards > Sarwar Erfan
-- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
