[web2py] how to test text-type field on equality (in mssql) ?

[Stef Mientki]

hello,

How should I test a text-type field in a mssql database

    Query = DB_Mod.Field_Ex.Tabel == '%s' % ( Name )

where the field "Tabel" is a text-type field,
gives the following error.

ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL 
Server]
The data types text and varchar are incompatible in the equal to operator. 
(402) (SQLExecDirectW)')

Changing the type to "string" seems to work ok.

thanks,
Stef Mientki