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" <[email protected]> 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 <[email protected]>: >> 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" <[email protected]> >> написал: >> >> 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 <[email protected]> wrote: >>> What do you mean by "remove the quotes"?... >> >>> On Sun, Jul 25, 2010 at 10:05 AM, Federico Paolinelli >>> <[email protected]>wrote: >> >>> >>> >>> >>> > Just to add more information to anybody who is interested in this >>> > topic, it is necessa... >> >>> > >>> > [email protected]<android-developers%[email protected]> <android-developers%[email protected]<android-developers%[email protected]> > >> >>> > 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 [email protected] >> To unsubscribe from this group, send email to >> [email protected]<android-developers%[email protected]> >> 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 [email protected] > To unsubscribe from this group, send email to > [email protected]<android-developers%[email protected]> > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
