ah, I see. I always use the case insensitive code page, which is probably
why I never had such an issue.
On Tuesday, September 23, 2014 2:13:15 PM UTC-7, Niphlod wrote:
>
> 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.
