[Mono-list] Mono.Data.SqliteClient always report text
julien at sobrier.net
Wed Dec 14 01:01:13 EST 2005
Aaron Bockover wrote:
> Internally in sqlite, everything is stored as a string, regardless of
> what type a column was assigned during table creation.
> The only way to know the "type" is to parse the table definition from
> the sqlite_master table. This should probably be done for convenience
> inside Mono.Data.SqliteClient.
> For instance, run this query:
> SELECT sql FROM sqlite_master WHERE name="Tracks";
> That will return the SQL used to create the "Tracks" table. You can then
> parse that result to build a map of column names->types.
> There is some example code for this in Banshee:
Thanks a lot, I'll look at it.
More information about the Mono-list