MYSQL > inserting steam id in int(11) with nosteam account that seems to long
<p>A friend of mine is asking me for help, he has servers for steam games. He uses a mysql data base and has a plugin on his game that stocks STEAM ID (ID of a player in game)</p>

<p>I've tested the data out of the game (STEAM ID conversion from 64bit to 32bit) and compare it to what is inserted in the db... the results are not equal... </p>

<p>Strangely an ID "2150032574" become in mysql data field int(11) "-2144934722"</p>

<p>I have tested all the code PHP and SMX in the game to verify all datas... and according to me (but i am not sure) it would come from the SQL and the relation of the data (ID) lenght and not from the code.</p>

<p>Could it be possible that the length of the ID is too big (maybe because of the unsigned ID value?) and is converted i don t know how into that negative value ?</p>

<p>And what could i do to fix this problem ? I imagined to change int(11) into a varchar(128) for example... but that seems so so so brutal and abnormal for me... </p>

<p>Please could someone help ?</p>

<p>Cheers.</p>