On 19 Oct 2013, at 9:06pm, Mohsen Pahlevanzadeh <moh...@pahlevanzadeh.org> 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 complicated. Try it and see if you get what you want. If not, post again and tell us what wasn't happening the way you wanted. > 2. how to define date type? There are five (arguably four) data types in SQLite and you can read about them here: <http://www.sqlite.org/datatype3.html> Anything complicated you declare will be ignored. For instance varchar(200) is interpreted as a straight text field with no limit on length. > I can data entry from my program into mysql but i can't insert into > sqlite... What is your programming language ? What are you doing ? What result code is returned ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users