exploring contacts db
satya - Saturday, October 30, 2010 11:25:09 AM
no such collation sequence phonebook
no such collation sequence phonebook
satya - Saturday, October 30, 2010 11:27:28 AM
looks like there is a problem with opening these databases
satya - Saturday, October 30, 2010 11:29:53 AM
collation sequence
collation sequence
Search Google for: collation sequence
Search Android Developers Group for: collation sequence
Search Android Beginers Group for: collation sequence
satya - Saturday, October 30, 2010 11:32:20 AM
how to add custom collations to sqlite
how to add custom collations to sqlite
satya - Saturday, October 30, 2010 11:38:30 AM
defining new collation sequences for sqlite
defining new collation sequences for sqlite
This is not entirely useful. This article points out the functions in (possibly) a dll that can be added to sqlite.
It is not clear how Android specific collation sequences can be made available to sqlite3 that is not on the device or the emulator.
satya - Saturday, October 30, 2010 11:44:55 AM
Another reference to the android phonebook collation problem
http://code.google.com/p/cyanogenmod/issues/detail?id=2251
Summary
"The sqlite3 binary needs to be compiled such that it includes those collations, otherwise it will not be able to execute queries on DBs that use them, which are now standard in Android 2.2. I think linking it against /system/lib/libsqlite.so may be a solution"
satya - Saturday, October 30, 2010 11:48:33 AM
android sqlite manager
http://sourceforge.net/projects/asqlitemanager/
Not sure if this will help. Looks like one will need an updated sqlite dll that is customized by android
satya - Saturday, October 30, 2010 11:55:17 AM
sql command to remove collation in sqlite3
sql command to remove collation in sqlite3
satya - Saturday, October 30, 2010 12:02:28 PM
More information on collating functions from sqlite
http://www.sqlite.org/datatype3.html
I am hoping I can find how to remove collation sequences defined by Android so that the database can be opened by sqlite3 tools.
satya - Saturday, October 30, 2010 12:03:19 PM
example
CREATE TABLE t1(
x INTEGER PRIMARY KEY,
a, /* collating sequence BINARY */
b COLLATE BINARY, /* collating sequence BINARY */
c COLLATE RTRIM, /* collating sequence RTRIM */
d COLLATE NOCASE /* collating sequence NOCASE */
);
satya - Saturday, October 30, 2010 12:07:43 PM
Key Tables in the contact database
contacts
groups
data
mimetypes
raw_contacts
satya - Saturday, October 30, 2010 12:10:40 PM
mimetypes (id/mimetype)
vnd.android.cursor.item/email_v2
vnd.android.cursor.item/im
vnd.android.cursor.item/postal_address_v2
vnd.android.cursor.item/photo
vnd.android.cursor.item/phone_v2
vnd.android.cursor.item/name
vnd.android.cursor.item/organization
vnd.android.cursor.item/nickname
vnd.android.cursor.item/group_membership
vnd.android.cursor.item/website
vnd.android.cursor.item/none
satya - Saturday, October 30, 2010 12:12:10 PM
accounts (account_name/accoun_type)
your_email_address, com.google
satya - Saturday, October 30, 2010 12:14:03 PM
blank account type
There seem to be a blank row with blank account type.
satya - Saturday, October 30, 2010 12:14:24 PM
android contacts blank account
android contacts blank account
satya - Saturday, October 30, 2010 12:22:47 PM
sqlite binary updated with android phonebook collation
sqlite binary updated with android phonebook collation
Search for: sqlite binary updated with android phonebook collation
satya - Saturday, October 30, 2010 12:25:32 PM
add collation dll sqlite dll
add collation dll sqlite dll
satya - Saturday, October 30, 2010 12:28:04 PM
writing extensions for sqlite
satya - Saturday, October 30, 2010 12:37:32 PM
figuring out android sqlite version
figuring out android sqlite version
Looks like 3.6.22 and above for recent releases.
Current sqlite version is 3.7.3 (Oct 2010)
3.6.22 is from (Jan 2010)
satya - Saturday, October 30, 2010 12:46:45 PM
android phonebook collation
android phonebook collation
satya - Saturday, October 30, 2010 12:58:07 PM
android 2.2 adding a contact
android 2.2 adding a contact
satya - Saturday, October 30, 2010 1:00:33 PM
android 2.2 users guide
I didn't know such a thing existed
satya - Saturday, October 30, 2010 1:11:47 PM
android contacts no account
android contacts no account
satya - Saturday, October 30, 2010 1:57:04 PM
android contact lookupkey
android contact lookupkey
satya - Saturday, October 30, 2010 1:57:33 PM
android quick contact
android quick contact
satya - Saturday, October 30, 2010 1:59:56 PM
android updating a contact which account
android updating a contact which account
satya - Friday, November 12, 2010 10:39:47 AM
A list of sqlite management tools