If you are using a case-sensitive database it probably either has a
function that converts strings to lower (or upper) case, or else a
case-insensitive comparison function.
Rewrite your where clause to use one of those functions, e.g.
"where caseinsensitivecomparison('Bill', name) is true"
Probably this is the only one solution:
https://www.hibernate.org/293.html
2009/7/13 Anand
> In that case , Oracle data stored is case sensitive not like sql server
>
>
> On Mon, Jul 13, 2009 at 4:14 AM, Andrea Ottaviani wrote:
>
>> I'm using Oracle...
>>
>> 2009/7/13 Ice-Man
>>
>>First of
In that case , Oracle data stored is case sensitive not like sql server
On Mon, Jul 13, 2009 at 4:14 AM, Andrea Ottaviani wrote:
> I'm using Oracle...
>
> 2009/7/13 Ice-Man
>
> First of all, we need know witch DataBase do u use?!! For instance,
>> Oracle is case sensitive!! :o
>>
>> Ice-Man
>
I'm using Oracle...
2009/7/13 Ice-Man
> First of all, we need know witch DataBase do u use?!! For instance,
> Oracle is case sensitive!! :o
>
> Ice-Man
>
>
>
> 2009/7/10 Andrea Ottaviani
>
>> Mhm...
>> the problem is on the parameter passing:
>> Ex.: if i have in Bill in the tabel Person, a
First of all, we need know witch DataBase do u use?!! For instance,
Oracle is case sensitive!! :o
Ice-Man
2009/7/10 Andrea Ottaviani
> Mhm...
> the problem is on the parameter passing:
> Ex.: if i have in Bill in the tabel Person, and i search for bill it
> doesn't work...
> i need a sugg
Mhm...
the problem is on the parameter passing:
Ex.: if i have in Bill in the tabel Person, and i search for bill it
doesn't work...
i need a suggestion...
2009/7/10 Bill Gordon
> Andrea,
>
> Typically this is a database configuration setting. Java items like named
> queries and their paramet
Andrea,
Typically this is a database configuration setting. Java items like
named queries and their parameters are case sensitive, but database
operations like where clauses and comparisons are case sensitive or
insensitive depending on database configuration. For example, SQL
server is b
