search

nmadhire / jwpl

Automatically exported from code.google.com/p/jwpl
0 stars 0 forks source link

[API] getPage performs case insensitive query on utf_general_ci #99

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
getPage queries should be case sensitive.
On DBs with collation utf8_general_ci, queries are case insensitive.
A solution would be to switch to utf8_bin.

However, the preferred solution is to:
1. Allow case insensitive queries, but deliver the whole result set. (currently 
just the first item is returned)
2. Allow case sensitive queries. This can be simulated by post-filtering the 
above mentioned results set and returning the exact String match for the given 
title.

Original issue reported on code.google.com by oliver.ferschke on 3 Jul 2012 at 2:00

GoogleCodeExporter commented 9 years ago

Original comment by oliver.ferschke on 3 Jul 2012 at 2:01

GoogleCodeExporter commented 9 years ago 
Also, the first character of page titles should not be upper-cased any more.

Original comment by oliver.ferschke on 3 Jul 2012 at 2:03

GoogleCodeExporter commented 9 years ago 
Fixed in latest snapshot.
Two new methods getPages() and getPageIdsCaseInsensitive()

Original comment by torsten....@gmail.com on 20 Aug 2013 at 1:39

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r776.

Original comment by torsten....@gmail.com on 20 Aug 2013 at 1:39

GoogleCodeExporter commented 9 years ago

Original comment by oliver.ferschke on 11 Sep 2014 at 1:35

GoogleCodeExporter commented 9 years ago

Original comment by oliver.ferschke on 11 Sep 2014 at 1:36