I like the UCASE solutions posted here better, but what I'm doing for MySQL has been working:
I changed the standardjbosscmp-jdbc.xml file, changing the java.lang.String mapping from a "VARCHAR(250) BINARY" to just "VARCHAR(250)", and MySQL does a case-insensitive compare by default I guess. It was a quick and dirty fix, but has been working fine. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846101#3846101 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846101 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user