Hello All,
i have created an alias function which will compare the argument to an
Arabic String then return an Arabic String like this:
create alias sexgroup as $$
String sexGroup(String s){
String r=null;
if (s.equals("ذ"))
r= "الذكور";
else if(s.equals("ا") || s.equals("أ"))
r="الإناث";
return r;
}$$
but the problem is that it always returns null, like : "select
name,sexgroup(sex) as sex from test".
i found that none of the conditions evaluates to true although the
column "sex" always contains one of the strings used in the
"s.eqauls" comparison.
i think that the problem is related to encoding, the table uses utf-8,
and maybe the compiled alias function does not. So is there a way to
make the function compile using utf-8 encoding?
Thanks in advance
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
