Hi all, Has any of you tried the UCASE function with accented characters?
Recently I had to use the 'UCASE' function in my jboss queries and I was surprised to find that the anonymous wrote : UCASE('ÃÂ') = 'ÃÂ' expression used in the WHERE condition resulted FALSE, whereas anonymous wrote : UCASE('e') = 'E' resulted TRUE. Why UCASE doesn't work with accented characters? The toUpperCase() method of the java.lang.String object has no problems to perform such a simple conversion. I use jBoss 3.2.3. All advice is appreciated except that I should introduce another field to my database table that store the upper-case-converted version of the same string :-). Thanks in advance. PÃÂszti <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825674#3825674">View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825674>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user