Thanks for the clarification. My existing database uses BIT fields, so I will be sticking to mssql for now.
On Feb 14, 4:17 pm, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > The difference is subtle. > > mssql is the first version of the adapter, the one that everybody > uses. It stores data as UTF8 but in ascii. That means the length of > the fields is not the number of unicode chars but the length of the > utf8 encoded chars. It also uses BIT for booleans. > > mssql2 uses unicode so length is correct and CHAR(1) (T or F) for > booleans. This is newer and less tested. > > On Feb 14, 1:15 pm, Ross Peoples <ross.peop...@gmail.com> wrote: > > > > > > > > > I am new to web2py and I just finished reading the book and have > > started to develop my first application. I recently had the same > > problem mentioned in this > > thread:http://groups.google.com/group/web2py/browse_thread/thread/e620c5708f... > > > I was wondering though, what is the difference between using mssql:// > > and mssql2? I am currently developing an application using am existing > > database on Microsoft SQL Server 2000 that will eventually be upgraded > > to Microsoft SQL Server 2008 R2. > > > Thanks