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:
> <init-param characterEncoding="utf8" />
> on the database driver in resin.conf
> ----- Original Message -----
> Subject: [Resin-interest] java mysql and utf8
> Date: Sat, 05 Apr 2008 07:57:21 +0200
> From: Riccardo Cohen
> 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
> 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.
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