SQLite field 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: SQLite field type (/showthread.php?tid=252784)
+- 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: SQLite field type (/showthread.php?tid=252784)
SQLite field type - Owenlishious - 02.05.2011
im using this SQLite Database Browser...already created a table.
But now i want to save some floats (X,Y,Z coords), but i dont see the float option on the dropdown list. All it has is TEXT,NUMBERIC,BLOB,INTEGER PRIMARY KEY.
soo which one i need to use? (im a bit new to this thing
)thank you
Re: SQLite field type - Joe Staff - 03.05.2011
In SQLite all tables are actually string tables, the type is more of a classification than a rule.
Re: SQLite field type - Owenlishious - 03.05.2011
so there isent a way to insert any floats right?
Re: SQLite field type - Joe Staff - 03.05.2011
Just insert it as a string, like you do anyway...
Re: SQLite field type - Owenlishious - 03.05.2011
alright thank you
but which do i choose, TEXT,NUMBERIC,BLOB or INTEGER PRIMARY KEY? cause im creating the table now.
big thanks
Re: SQLite field type - Joe Staff - 03.05.2011
Doesn't matter, numeric makes most since
Re: SQLite field type - Georgelopez1 - 03.05.2011
You should use MySQL :S
Re: SQLite field type - Owenlishious - 03.05.2011
Quote:
|
Originally Posted by Georgelopez1
 You should use MySQL :S
|
i been hacked once with mysql, i rather keep the save files as secured as the server files itself.btw silenthunter thanks alot
cheers!
Re: SQLite field type - Joe Staff - 03.05.2011
The ONLY reason you should use MySQL is for read-only information for websites and other things. SQLite is faster and more secure, text files are faster still.
Re: SQLite field type - DRIFT_HUNTER - 03.05.2011
Quote:
|
Originally Posted by Owenlishious
i am a paranoid person
i been hacked once with mysql, i rather keep the save files as secured as the server files itself.btw silenthunter thanks alot cheers! |