Thanks a lot. You saved me from doing an ugly filth :-) . I didn't expect that the number with a + was suitable to be interpreted as a number.
Thanks again, Federico On Jul 25, 12:50 am, DanH <[email protected]> wrote: > Did you put quotes around the string? If SQLite sees an un-quoted > string it's going to interpret it as numeric if possible. SQLite > ignores the data type of columns. > > On Jul 24, 5:12 pm, Federico Paolinelli <[email protected]> wrote: > > > I spent a lot of time on this. > > > I was trying to store an incoming call number in sqlite. I'm in Italy, > > so the number was something like +39123123. > > > What happened was that after putting and removing it from sqlite as a > > string , the leading "+" was gone. > > > In the table creation the record is a string. > > I call ContentValues.put(String, String) and then I get the value from > > the cursor using getString(). > > > Moreover; I tried to put something before the "+", like "aa+39123123", > > the query returns the expected value. I suspect that for some reason > > sqlite converts the String to a number, and when returns it back the + > > is not given back. > > > What I think I am going to do (even if I am disgusted) is to add > > something to the string and remove it later. > > > Anyway, does anybody has an explanation?? > > Many thanks in advance, > > > 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] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
