Table 5: Query Results when Accepting NULL and Empty
String as Valid Integers
|
Keycol |
string |
is_numeric |
is_int |
|
1 |
12345 |
1 |
1 |
|
2 |
abc |
0 |
0 |
|
3 |
NULL |
0 |
1 |
|
4 |
1E3 |
1 |
0 |
|
5 |
12.4 |
1 |
0 |
|
6 |
+123 |
1 |
1 |
|
7 |
-2345 |
1 |
1 |
|
8 |
|
0 |
1 |
|
9 |
$123 |
1 |
0 |
|
10 |
2147483647 |
1 |
1 |
|
11 |
2147483648 |
1 |
0 |
|
12 |
9223372036854775808 |
1 |
0 |