On Fri, Mar 4, 2011 at 11:55 AM, Mauricio Pazos <mauricio.pa...@axios.es>wrote:
> On Thursday 03 March 2011 01:27:55 pm Jody Garnett wrote:
> > I do not remember a reason; their may be a global hint to switch the
> > default?
> >
> > My best guess would be trying to be nice to CQL users.
> Usually, the LIKE clause, in SQL, is case sensitive (but there are DBMS
> implementation that it is case insensitive)
>
>
> The insensitive like query is solved in different way by example:
> 1 - Postgres: ILIKE ...
> 2- Oracle: regexp_like ...
> 3- My SQL: aColumn COLLATE latin1_general_cs LIKE ...
>
>
> Looks like the "COLLATE" is the ISO solution
> http://savage.net.au/SQL/sql-2003-2.bnf.html#xref-COLLATE
>
>
> Some times ago we talked about to implement "ILIKE" as CQL extension.
> http://jira.codehaus.org/browse/GEOT-2359
>
>
> But now, I am reflecting about the COLLATE option.
>
>
> comments???
>
I like ILIKE :-)
Collate seems more difficult to use and understand for the normal user.
So you agree that building a like filter in a case insensitive manner sounds
like a bug?
Mind, CQL LIKE today is parsed into a case insensitive filter
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 333 8128928
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
