Re: [sqlite] migration from mysql to sqlite

On 19 Oct 2013, at 9:06pm, Mohsen Pahlevanzadeh wrote: > 1. how can define a unicode field and tables? In SQLite all text fields are unicode fields. Just make sure you are feeding them text which is in unicode. Making sure unicode fields are sorted in the order you expect is far more compl

[sqlite] migration from mysql to sqlite

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,