Unfortunately, mssql:// is there only for MSSQL 2000 (and others derived from that baseclass).
It's a known issue...unfortunately there's no operator / function that can turn a 'text' into a something that gets a LIKE applied correctly without the possibility of truncation, not until MSSQL 2005 at least. If you're on 2012, use mssql4:// by default. Related note: I'm pushing a PR to use the same mappings in mssql3:// too that use correct mappings instead of the base ones. PS: you can then think at a mssql3:// by default if you're at least on 2005 and at mssql4:// if you're at least on a 2012 On Monday, September 22, 2014 11:45:41 PM UTC+2, Leonel Câmara wrote: > > The MSSQLAdapter could cast to varchar and avoid the problem. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
