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