I have this :

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

I'll check in the driver if there is a sort of parameter like charset or 
encoding...

Knut Forkalsrud wrote:
> 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

-- 
Très cordialement,

Riccardo Cohen
-------------------------------------------
Articque
http://www.articque.com
149 av Général de Gaulle
37230 Fondettes - France
tel : 02-47-49-90-49
fax : 02-47-49-91-49



_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Reply via email to