Storing "String" as "TEXT" instead of "VarChar" in SQLite - WP8
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
Although there is no difference between Text and Varchar data types in SQLite, but if you want to change it the way you want, do this:
If you are using sqlite-net (SQLite.cs & SQLiteAsync.cs) in your WP8.0 app, then go to SQLite.cs class and find the SqlType method (about line 1863). Then you can see if (clrType == typeof(String)) statement. If you prefer Text data type then you can change varchar to text as you like.
As to my knowledge, Text type accepts UTF-8 and special chars symbols, etc. Its not the same with type Varchar.