Ooops. Thanks a lot, it was driving me mad. Sorry for having bothered you all.
2010/7/25 Dmitri Plotnikov <dplotni...@google.com>: > This should not be happening if the column type is declared correctly. It > should be declared as TEXT. See http://www.sqlite.org/datatype3.html > > Cheers, > Dmitri > > On Jul 25, 2010 12:14 PM, "Federico Paolinelli" <fedep...@gmail.com> wrote: >> That's what I did, as I said before: >> >> "What I think I am going to do (even if I am disgusted) is to add >> something to the string and remove it later. " >> >> but I thought there was a more standard way to do it as suggested by Dan >> >> 2010/7/25 Kostya Vasilyev <kmans...@gmail.com>: >>> Why not prefix the number with some arbitrary, predefined character? >>> >>> Sort of like the leading single quote in Excel. >>> >>> Then remove it after getting the value from the database. >>> >>> Just make sure it's not a valid phone number character - like, any letter >>> from A to Z will work... >>> >>> -- >>> Kostya Vasilyev -- http://kmansoft.wordpress.com >>> >>> 25.07.2010 22:26 пользователь "Federico Paolinelli" <fedep...@gmail.com> >>> написал: >>> >>> As Dan stated, the problem is the leading + of an international number >>> that gets lost in the insert / get process. >>> >>> If I put a number like "+39123123", when I perform a getString I get >>> back something like 39123123, this is because sqllite thinks it is a >>> pure number. >>> >>> (Ciao anche a te) >>> >>> On 25 Lug, 11:30, YuviDroid <yuvidr...@gmail.com> wrote: >>>> What do you mean by "remove the quotes"?... >>> >>>> On Sun, Jul 25, 2010 at 10:05 AM, Federico Paolinelli >>>> <fedep...@gmail.com>wrote: >>> >>>> >>>> >>>> >>>> > Just to add more information to anybody who is interested in this >>>> > topic, it is necessa... >>> >>>> > >>>> > >>>> > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com> >>> >>>> > For more options, visit this group at >>>> >http://groups.google.com/group/android-developers?hl=en... >>> >>>> Check out Launch-X <http://android.yuvalsharon.net/launchx.php> (a >>>> widget >>>> to >>> >>>> quickly access your favorite apps and >>>> contacts!)http://android.yuvalsharon.net >>> >>> -- >>> You received t... >>> >>> -- >>> 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 >> >> >> >> -- >> -------- >> Federico >> >> -- >> 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 > > -- > 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 -- -------- Federico -- 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
