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!