SA-MP Forums Archive
MySQL integer-based column type - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL integer-based column type (/showthread.php?tid=571007)



MySQL integer-based column type - Parallax - 15.04.2015

Would cache_get_row_int work on any integer-based column type (TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT)?


Re: MySQL integer-based column type - MP2 - 15.04.2015

Yes. Works for boolean also. However, note that PAWN is typeless, and all integers are 32-bit signed.


Re: MySQL integer-based column type - Konstantinos - 15.04.2015

Having BIGINT and a really long number will just give:
pawn Code:
[ERROR] cache_get_row_int - invalid datatype
in mysql logs and return nothing. Just keep in mind that values shouldn't exceed 2.1 billions.


Re: MySQL integer-based column type - Parallax - 15.04.2015

Ah, thanks MP2. Thanks for the extra tips too, Konstantinos!