Re: ODBC formatting
- Posted by Mike777 <anon4321 at gm?il.c?m> Dec 18, 2007
- 600 views
Matt Lewis wrote: > > Mike777 wrote: > > > > I can read my ODBC databases, but I'm having a tough time figuring out how > > to > > interpret somee of the data types. > > Is this just a fault in the ODBC driver that I'm using and therefore there > > is > > "no hope"? Or is there a format I can use to visually display these values > > properly? > > I think this is the fault of the wrapper. Looking at the code, it appears > to interpret a SQL_INTEGER as an unsigned int, which seems incorrect. > > And it doesn't understand SQL_SMALLINTs at all. Should I just plan on insisting that all data be text based (even numbers) or is there some wrapper modification I should consider (I'm certainly willing to edit odbc.e to change the way it deals with SQL_INTEGER and SQL_SMALLINT)? Mike