In that case , Oracle data stored is case sensitive not like sql server On Mon, Jul 13, 2009 at 4:14 AM, Andrea Ottaviani <andreo...@gmail.com>wrote:
> I'm using Oracle... > > 2009/7/13 Ice-Man <derlon.aliend...@gmail.com> > > 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 <andreo...@gmail.com> >> >>> 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 <gord...@phototype.com> >>> >>> 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 >>>> by default case insensitive so the conditional >>>> @txt = 'consistent' >>>> evaluates to true if @txt has either value 'consistent' or 'Consistent' >>>> >>>> bill >>>> >>>> >>>> On Jul 10, 2009, at 8:50 AM, Andrea Ottaviani wrote: >>>> >>>> Hi guys, i need a suggestion >>>>> I have an application (web application, hibernate based) and i have to >>>>> make it case-insensitive on select and insert queries >>>>> It is possible by hibernate ? >>>>> Or i need to change all the queries in the application? >>>>> regards >>>>> andrea >>>>> >>>>> -- >>>>> L'informazione non è conoscenza >>>>> La conoscenza non è saggezza >>>>> La saggezza non è verità >>>>> La verita' non è bellezza >>>>> La bellezza non è amore >>>>> L'amore non è musica >>>>> La musica è il meglio >>>>> (FZappa) >>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> L'informazione non è conoscenza >>> La conoscenza non è saggezza >>> La saggezza non è verità >>> La verita' non è bellezza >>> La bellezza non è amore >>> L'amore non è musica >>> La musica è il meglio >>> (FZappa) >>> >>> > > > -- > L'informazione non è conoscenza > La conoscenza non è saggezza > La saggezza non è verità > La verita' non è bellezza > La bellezza non è amore > L'amore non è musica > La musica è il meglio > (FZappa) > > > > -- AnAnD JAVA / J2EE Developer, . --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en -~----------~----~----~----~------~----~------~--~---
