Dear all,
I'm newbie in sqlite, and i migrated to sqlite from mysql. I have the folloiwng questions: 1. how can define a unicode field and tables? 2. how to define date type? I created my table such as: CREATE TABLE `buyers` ( `id` bigint(20) NOT NULL , `name` varchar(200) DEFAULT NULL, `name_type` tinyint(4) DEFAULT NULL, `addresses` text , `telephones` text , `emails` varchar(60) DEFAULT NULL, `job_background` varchar(200) DEFAULT NULL, `agent_first_name` varchar(200) DEFAULT NULL, `agent_attributes` text , `agent_last_name` varchar(200) DEFAULT NULL, `agent_values` text , PRIMARY KEY (`id`) ) Or CREATE TABLE `materials` ( `id` bigint(20) NOT NULL , `name` varchar(200) DEFAULT NULL, `bought_price` bigint(20) DEFAULT NULL, `bought_date` date DEFAULT NULL, `minimum_bound` int(11) DEFAULT NULL, `stock` int(11) DEFAULT NULL, `imported_party_attributes` text , `imported_party_values` text , `measure_attributes` text , `measure_values` text , `sellers_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) I can data entry from my program into mysql but i can't insert into sqlite... Where's my problem? Yours, Mohsen _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users