Storing "String" as "TEXT" instead of "VarChar" in SQLite - WP8

Question

I'm storing my Data in local database using SQLite. I've string typed few variables to store. Now, when I store that string variables, it is being stored as "VARCHAR" (as in the picture below).

Picture 1

But I want to store those strings as "TEXT" type in SQLite. (as in the picture below)

Picture 2

The class I'm using to store db is as below:

public class abc
{
    [SQLite.AutoIncrement, SQLite.PrimaryKey]
    public int _id { get; set; }
    public string a { get; set; }
    public string b { get; set; }
    public string c { get; set; }
    public string d { get; set; }
    public string e { get; set; }
    public string f { get; set; }
    public string g { get; set; }
    public DateTime date { get; set; }

}

any help will be appreciated.

Answer 1

varchar is TEXT in SQLite so u need not to worry!

Internally the data is always stored as TEXT, so even if you create table with VARCHAR(LEN), SQLite is going to follow the rules of TEXT data type