1 Oct
2018
1 Oct
'18
5:50 p.m.
Daniel-Constantin Mierla writes:
You have to change:
if(VAL_TYPE(ROW_VALUES(row) + 11) != DB1_INT) {
to something like:
if(VAL_TYPE(ROW_VALUES(row) + 11) != DB1_INT && VAL_TYPE(ROW_VALUES(row) + 11) !=
DB1_UINT) {
Why do I need to test both DB1_INT and DB1_UINT, since the column cannot
hold a negative integer value?
The alternative is to remove UNSIGNED from the column
definition. Alexander Dubovikov mentioned that there is a MySQl server
setting for strict data type usage, that is turned on, but can be
turned off via mysql server (or client) config.
There is reason why the column in unsigned int. I want to be able store
in that column positive int value 4294967295 (0xFFFFFFFF). If I change
the column to int, my understanding is that is cannot anymore store this
value.
-- Juha