I observed a strange behavior with INT-Values in a MySQL-Database. On my local test-server everything works fine. But when I deploy my webapp as standalone-app on my Live-server, something strange happens.
Instead of receiving the desired value “1” for the user-id, I get a value “4294967297”. I’ve got another id which should also be set to “1”, there I get “5764608175869263873”.
The complete received mysql-data looks like this (I get the result als JSONItem):
{"SEL_LoginCheck":{"4294967297":{"id_user":"4294967297","id_rolle":"1729382909745299457","modifiedTS":"2015-11-09 17:44:42","accountTS":"2015-11-09 16:45:13","user_name":"Frank","user_mail":"somemail@mail.de","passwort":"dcff31c85bde9760c5fd8961a45fd70a","optin":"1","optinTS":"2015-11-09 16:45:13"}}}
It should look like this (and looks like this on my test server)
{"SEL_LoginCheck":{"1":{"id_user":"1","id_rolle":"1","modifiedTS":"2015-11-09 17:44:42","accountTS":"2015-11-09 16:45:13","user_name":"Frank","user_mail":"somemail@mail.de","passwort":"dcff31c85bde9760c5fd8961a45fd70a","optin":"1","optinTS":"2015-11-09 16:45:13"}}}
When I change the format in my mysql database to BIGINT, the desired result shows up: I get the correct numbers.
I don’t think that this is a XOJO issue. Just wanted to give a hint and how I solved it. Gave me some sort of a headache.