sorry for being not that deeply explicit in the previous post..... contains() on list:something is case-insensitive. If you try to create a table with a TEXT field, then do a *LOWER(textfield) LIKE '%whatever%'* on it. You'll find out that while lots of functions can be applied to varchar, not all of them can be used on text (lower() being one of them). If you try a simple db(thetable.textfield.lower().like('%whatever%')) the same issue arises..... To have consistent resultsets independently on the collation being set on the database, the workaround may be identified in doing a *LOWER(CONVERT(VARCHAR(MAX), textfield)) LIKE '%whatever%'*, but on sql2000, varchar(max) isn't allowed. You'll find yourself screwed because you can at most use *VARCHAR(8000)*, but doing so textfield will be truncated at 8000 chars.
tl;dr: either you use mssql:// and then convert by hand every "text" field into a varchar(max) if you are on >= 2005, or with mssql:// you'll face the issue, there's no way around it without falling into limitations (such as, on = 2000, changing by hand every text into a varchar(8000), knowing that you'll store AT MOST some text 8000 chars long). And let's face it, text is "officially" going towards being discontinued. Varchar(max), where available, has better performances and no cons. Given that mssql3:// and mssql4:// are created with the original purpose of circumventing another "famous" issue with pagination, and that mssql3:// is meant to be used with >= 2005, while mssql4:// with >= 2012, there are overrides in place to make every Field(..., 'text') created as a varchar(max) by default, that will annihilate the issues with columns being "limited" by what the "text" type offers. -- 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.