On Mon, Jun 27, 2011 at 3:41 PM, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > Your suggested change is in trunk. I am trusting you one this since I > am not a MSSQL user and cannot test it. If anybody else is using > MSSQL2Adaperter, i.e. > > DAL('mssql2://....') > > please check that this change does not break your code. > Also, the change to how booleans are stored (from BIT to CHAR(1)) is causing a problem. The values are stored as a '0' or '1' (char, not integer), so in BaseAdapater.parse(), the value of '1' does not parse to True, so every boolean value is shown as False.
I don't know whether the fix should be in parse() or represent(). I found a short discussion on booleans here: http://groups.google.com/group/web2py/browse_thread/thread/ab015825bea4edb4?pli=1 Eric