Hi folks, Nokia uses SQLite on Windows to exchange data between PC and a cellphone using what they call Nokia PC Suite.
Not very surprising, as Symbian is the OS on Mokia high end phones, but SQLite is also used in exchanges with its 6233 model, which doesn't run Symbian, but Nokia OS, with Series 40 UI. I'm not sure if SQLite is used in the cellphone itself, I only found a SQLite3 database in a PC disk directory used for exchanges. Schema: PRAGMA page_size=1024; PRAGMA default_cache_size=2000; PRAGMA encoding=UTF-8; PRAGMA legacy_file_format=1; CREATE TABLE contact_general ( uid PRIMARY KEY, name TEXT, first_name TEXT, middle_name TEXT, last_name TEXT, nickname TEXT, formal_name TEXT, versit_object BLOB, versit_length INTEGER ); CREATE TABLE contact_numbers ( gen_info_uid INTEGER, number_text TEXT, number_type TEXT ); CREATE TABLE sms_folders ( sms_folder_name TEXT, sms_view_name TEXT, sms_options INTEGER ); CREATE TABLE sms_messages ( sms_uid PRIMARY KEY, sms_info_field INTEGER, sms_data_length INTEGER, sms_data BLOB, sms_date_year INTEGER, sms_date_month INTEGER, sms_date_day INTEGER, sms_date_hour INTEGER, sms_date_minute INTEGER, sms_date_second INTEGER, sms_date_timezone INTEGER, sms_date_bias INTEGER, sms_folder TEXT, sms_address_1 TEXT, sms_address_1_type INTEGER, sms_address_2 TEXT, sms_address_2_type INTEGER ); CREATE VIEW sms_predefinbox_view AS SELECT * FROM sms_messages WHERE sms_folder='predefinbox'; Pictures: http://www.forum.nokia.com/devices/pics/6233_main.jpg http://www.nokia.com/search/images/logo_nokia_115_40.gif (I didn't find a real good one) -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
