Sorry I just found out what the _ci in the character collation meant: Case Insensitive. Using utf8_bin seems to work I hope that the database conversion will be ok.
sophana a écrit : > Hi > > I found out that ALL mysql search were case insensitive, even with the > WHERE statement (select and selectBy) > Sorry if it is a newbie question. Howcan I make all searches case sensitive? > On google I found that people use binary columns. Do you think I can > change all my columns to binary and it will work normaly? > How can I create case sensitive columns in sqlobject? > > > mysql> select login from Users where login='AsDf'; > +-------+ > | login | > +-------+ > | asdf | > +-------+ > 1 row in set (0.01 sec) > > > Thanks > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sqlobject-discuss mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
