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

[mdipierro]

This helps. I can fix it by tomorrow. Sorry for the inconvenience.

Massimo

On Jan 5, 9:39 am, Roman Bataev <roman.bat...@gmail.com> wrote:
> 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'));