I think so but I cannot say for sure. I am not expert on mssql.
On Mar 1, 5:03 pm, Stef Mientki <[email protected]> wrote: > On 14-02-2011 22:17, Massimo Di Pierro wrote:> The difference is subtle. > > as SQLserver uses utf-16, the size will double, > am I correct ? > > thanks, > Stef Mientki > > > > > > > > > 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 <[email protected]> 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
