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
