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???
cheers
--
Mauricio Pazos
www.axios.es
------------------------------------------------------------------------------
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
