Re: [sqlite] Convert and isnumeric function

[Wolfgang Rohdewald]

On Samstag 14 Mai 2005 00:31, Michael Evenson wrote:
>     case SQLITE_TEXT: {
>       const char *z = sqlite3_value_text(argv[0]);
>       for (i = 0; i < strlen (z); i++) {
>         if (!isdigit (z[i])) {
>           nResult = 0;
>           break;
>         }

this should return FALSE for -5, 1123.456.
In some locales, that might be written as 1'123,456 or 1,123.456
or whatever.

strtol()

seems to  what you need, see man strol()

-- 
Wolfgang