I use 'Like' on mssql 2000 pretty much every day, what are you saying? why can't it map to varchar?
On Monday, September 22, 2014 3:02:33 PM UTC-7, Niphlod wrote: > > 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.
