Size of Text type in SQLite Database on Android

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

Size of Text type in SQLite Database on Android

Postby download9719 » Fri Feb 06, 2009 2:10 am

I tried to search for the size of Text type in SQLite Database on Android, but I still not understand.
Can anyone teach me about that?

1. size of Text type in Android database
2. instead of Text, can we use Varchar type?
3. Is there any document about database design for Android?

Thanks a lot!
Best wishes!
Posts: 3
Joined: Tue Jan 27, 2009 1:23 pm


Postby bit » Thu Feb 12, 2009 3:57 am

1/2. I can't speak directly about SQLite on Android, but have you looked at ? It describes how the database works in general. There is a document on SQLite limits you may find useful, as well as the FAQ. So far with my first app I've not hit size problems storing text in a Text field.

3. Have you looked at the tutorial? It uses SQLite.
Junior Developer
Junior Developer
Posts: 19
Joined: Thu Dec 11, 2008 7:30 pm


Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 2 guests