Riccardo Cohen wrote:
> 2) search
>
> it fails to find any record :
>
> qr=globalaction.m_manager.createQuery("select u from userinfo u where
> u.lastname like '"+catalogchapter+"%' order by lastname");
>
> when catalogchapter is £ I find the record, when it is א or 种 it
> returns zero record without any error (result list count=0).
>
This must be a MySQL issue, either in the JDBC driver or on the server.
Make sure your table deals with extended unicode ranges. For example try:
show create table userinfo \G
You should get output like
CREATE TABLE userinfo (
.....
) ENGINE=InnoDB AUTO_INCREMENT=6796 DEFAULT CHARSET=latin1
If the charset is latin1 like in my example you may have problems
dealing with the Chinese characters.
-Knut
_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest
