query « sqlite « Java Database Q&A

1. SQLite3 Database written in Unicode - How to access it with ANSI queries stackoverflow.com

I have an SQLite3 databse I created in python. And by default it writes the database in Unicode. Now I am trying to query the database in a Java Applet using ...

2. Convert SQL Query result into array of strings stackoverflow.com

I am making queries to a SQLite3 database in Java using the SQLiteJDBC (Java JDBC driver for SQLite). If I make the SQL query SELECT name, pass FROM loginTable WHERE name='%s'; is ...

3. SQLite in Java: Ways to optimize my queries to make them return faster? stackoverflow.com

I am creating an application in Java that uses SQLite to store and search the data in a database. I am not sure if I am approaching this problem in the most ...

4. Why is my Cursor empty after this SQLite database query? stackoverflow.com

startTime and endTime are strings in the format "2011-07-22 13:00:00". The following code makes myCursor.moveToFirst() return false.

String sqlQuery = "SELECT * FROM myData WHERE 
    strftime('%Y-%m-%d %H:%M:%S', datetime) >= ...

5. Sqlite Query Issue stackoverflow.com

Alright, so I'm trying to store data in Sqlite. So I'm trying to store the id of the user with the a "line". Yet, it seems that the where clause is ...

6. How to query an encrypted field in SQLite stackoverflow.com

I need to encrypt a field in my sqlite database for android. I am going to use following code to do that. Understand I grap the code from a site. If ...

7. Java and SQLite not returning the same results after same query stackoverflow.com

Im using SQLite Administrator to manage my sqlite database, I have three tables, and I have a query that, when I run it on the administrator it works, but later in ...