sqlite and blob type for text

BIZ TMS Aurelius
1

I have a sqlite db that when I use the modeler comes up with a Blob type for the text fields.  Is there a way to force this to map to something more appropriate?  These are generally small text columns for things like name, address, etc.

2

You mean when you import the sqlite structure? 


SQLite doesn't have data types, all fields are the same type. To infer the data types from SQLite database, Data Modeler parses the original SQL statement that generated the table. Can you provide the SQL so we can have an idea of what's going on, and how do you expect Data Modeler to guess the field type?
3
 SQL create table statement below.   I want MeshStyle and Material to map to a string type.
I understand about SQLite's limitations regarding types.  And that TEXT types have no size restrictions. I guess I'm just inquiring as to what are my options, if any.

CREATE TABLE "PadVane"("MeshStyle" TEXT  NOT NULL, "StyleID" INTEGER PRIMARY KEY, "Density" REAL, "D1" REAL, "D2" REAL, "SA1" REAL, "SA2" REAL, "Voidage" REAL, "Material" TEXT)