[Mono-list] Mono.Data.SqliteClient always report text as DataTypeName

[Julien Sobrier]

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:
> http://cvs.gnome.org/viewcvs/*checkout*/banshee/src/Database.cs
> 
> --Aaron

Thanks a lot, I'll look at it.