Let’s start with an example: We have a table called StartDate with some dates stored into it as long (milliseconds) like in the image below: To understand better which date represents each record I will write below their dates: 1. Tuesday, February 5, 2013 8:10:17 PM GMT 2. Friday, February 1, 2013 8:10:17 PM GMT 3. Wednesday, February […]
In Android you can pull out the database only from emulator (you could pull out the database from a phone/device only if it is rooted). So if you want to pull out the database from emulator you should use ddms (ddms is located in Android sdk folder e.g. my Android folder is installed ProgramFiles so
In this tutorial I will show how to use a database in Android by creating the tables and columns using the SQLite Database Browser.1. So the first step is to download the SQLite Database Browser2. Make a new project and name the main java class that generates with the project “MyActivity”. 3. Now you have to go
If you want to select data from Database and you want to ignore the case of letters you should use COLLATE NOCASE in your query: “SELECT * FROMÂ myDataBaseName WHERE some_column= some_value COLLATE NOCASE” It’s not exactly an android issue but you might need some day in your android projects, so I hope it helps
