-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/10/2014 01:18 PM, jose isaias cabrera wrote: > I was able to figure out that comma's are more important than just > a 1000 number delemeter, so I received the right answer by taking > the commas out:
To help avoid this in the future, be aware that how developers deal with numbers and how users experience them are very different. People using your apps expect to see numbers in the normal way for them. For example thousands separators are useful, but note that some locales group differently (eg around ten thousands). Some use dots not commas, and others the other way around. Some use dots for the decimal point and others use a comma. Some don't use Arabic numerals (0, 1, 2, 3 etc) https://en.wikipedia.org/wiki/Decimal_mark#Digit_grouping Fortunately the operating system and programming environment provide ways to output numbers (and dates, currency etc) in the most appropriate way for the user. Widespread programming languages wouldn't work very well if numbers weren't consistently formatted (eg what happens if a developer in a different locale runs the code). Reflecting their origins, they almost always only accept the anglo-centric integer notation of no grouping and a dot as the decimal point. SQLite uses SQL which does the same. For you that means separating out text that you are using with SQLite, versus text that is shown/accepted from the user. If you mix them together you'll end up with unexpected behaviour, crashes, wrong results etc. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlQ4dEsACgkQmOOfHg372QS17gCdGr31RcjBKe7ncvHbR8yAyoCW dkAAoMZyiAzNIsVkirunvVWCh5ADspPq =fCjG -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users