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

[Duncan McQueen]

Will this error be related to DateTime values not being reported correctly?

On 12/14/05, Julien Sobrier <julien at sobrier.net> wrote:
> 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.
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>