Jump to content

Working with a database in sqlite


Bannmann_sam
 Share

Recommended Posts

're stuck with what field type in the list below. I will make 5 ferently databases that will eventually be built into the apps up a tablet. has tried me on something not quite get me to the way I think to have

 

Her is one of databases everything is written in Norwegian....

 

Kjøretøy idKommune Nr Kommune FylkeStasjons Navn Pre-hospitaltjenesteAlarmsentral 113Aktive Kallesignal BilummerTypebil Reg Nr Fabrikkmerke Modell Påbygg Betegnelse Års Modell HistorikkStatus

 

 

Link to comment
Share on other sites

list that I have listed should I hold on to add that database application that Herter absDB Database.here is the setup for fild type. INTEGER, TEXT, BLOB, DATETIME, FLOAT, boolean. what I have not figured out what is best to enter the list with! plan pulldown lists several,I wondered what was most these INTEGER, TEXT, BLOB, DATETIME, FLOAT, boolean? What do I use for what?

Edited by Bannmann_sam
Link to comment
Share on other sites

That question is too broad to answer in this format. Just use your common sense (obviously you won't save text as number or a timestamp as text). Every data type has its purpose.

 

That said, Please post specific questions when you have them or you can always refer to the manual:

 

http://dev.mysql.com/doc/refman/5.0/en/data-types.html

Edited by niche
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...