I don't see MEMO listed. I needed to use MEMO in Microsoft Access to handle char strings longer than 256.
However, I don't see any complaints by SQLite when I use MEMO. On Tue, Jan 31, 2017 at 10:33 AM, Hick Gunter <h...@scigames.at> wrote: > Yes. See http://sqlite.org/lang_createtable.html for details. I also suggest > you look at http://sqlite.org/datatype3.html too > > -----Ursprüngliche Nachricht----- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im > Auftrag von Clyde Eisenbeis > Gesendet: Dienstag, 31. Jänner 2017 17:07 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [sqlite] Does SQLite use field definitions? > > In the past, when using Access as a database, I have specified field > definitions. These field definitions have been used when creating a table. > > public const string stFIELD_DEFINITIONS = " fstPriority TEXT, fstInfo MEMO, > fstDateCreated TEXT, fstDateModified TEXT, fiKeyID INTEGER PRIMARY KEY "; > > Does SQLite (System.Data.SQLite) use field definitions too? > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This communication (including any attachments) is intended for the use of the > intended recipient(s) only and may contain information that is confidential, > privileged or legally protected. Any unauthorized use or dissemination of > this communication is strictly prohibited. If you have received this > communication in error, please immediately notify the sender by return e-mail > message and delete all copies of the original communication. Thank you for > your cooperation. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
