Thanks a lot it works perfectly !

Now that I see it, I admit that I should have read mysql connector docs 
more carefully. But actually everything is working so nice by defaults 
in general, and there are so many docs to read...



Mattias Jiderhamn wrote:
> Try
>   <init-param characterEncoding="utf8" />
> on the database driver in resin.conf
> 
>  /Mattias
> 
> ----- Original Message -----
> Subject: [Resin-interest] java mysql and utf8
> Date: Sat, 05 Apr 2008 07:57:21 +0200
> From: Riccardo Cohen
> 
> Hello
> I have a problem to build a full utf-8 application.
> I made a little sample that displays a list of items, and let the user
> edit/add/delete items.
> This works ok except with utf-8 chars.
> 
> 1) if I put characters like ꄈ or Щ in the database using phpmyadmin,
> they display correctly on the html page in the
> 
> 2) but if I want to change a string or add an item using these utf-8
> chars, the mysql db stores "?" instead
> 
> 3) if I search %Щ% I find nothing (while searching for "é" or "£" works
> all right)
> 
> to allow utf-8 I've done the following :
> 
> - uncomment utf-8 encoding in resin.conf
> - add response.setContentType("text/html;charset=utf-8"); in every
> response and
> in
> every jsp page
> - in mysql change all text fields into utf8 :
> name char(50) collate utf8_unicode_ci,
> 
> 
> This does not seams to be enough. As it works all right with phpmyadmin,
> I suppose this is a jdbc driver issue. I've downloaded the latest
> mysqljdbc (mysql-connector-java-5.1.6-bin.jar) and tried to set some
> encoding attribute in the resin.conf database specification (
> encoding="utf-8"/>), but it does not work.
> 
> Thanks for any help.
> 
> 

-- 
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