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
