[Owenlishious]

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

[Joe Staff]

In SQLite all tables are actually string tables, the type is more of a classification than a rule.

[Owenlishious]

so there isent a way to insert any floats right?

[Joe Staff]

Just insert it as a string, like you do anyway...

[Owenlishious]

alright thank you

but which do i choose, TEXT,NUMBERIC,BLOB or INTEGER PRIMARY KEY? cause im creating the table now.

big thanks

[Joe Staff]

Doesn't matter, numeric makes most since

[Georgelopez1]

You should use MySQL :S

[Owenlishious]

Quote:

Originally Posted by Georgelopez1 You should use MySQL :S

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!

[Joe Staff]

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.

[DRIFT_HUNTER]

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!

I bet it was sql injection and thats cos you didnt used mysql escape string