[web2py] Re: 1.79.2 -> 1.91.6 migration error (SQL Server BIT field seems to break)

[Roman Bataev]

The change you suggested did not make any difference - I get the same errors 
for both mssql:// and mssql2://. (and also, SQL Sever doesn't use utf8, it 
uses UCS-2).

Here is what print says:

1.79.2:

Both mssql2 and mssql:

SELECT Employees.employeeID, Employees.firstName, Employees.networkUsername, 
Employees.isManager FROM Employees WHERE 
(Employees.networkUsername='rbataev' AND Employees.isManager=1);

1.91.6:

mssql2:

SELECT  Employees.employeeID, Employees.firstName, 
Employees.networkUsername, Employees.isManager FROM Employees WHERE 
((Employees.networkUsername = N'rbataev') AND (Employees.isManager = 'T'));

mssql:

SELECT  Employees.employeeID, Employees.firstName, 
Employees.networkUsername, Employees.isManager FROM Employees WHERE 
((Employees.networkUsername = 'rbataev') AND (Employees.isManager = 'T'));