Problem with getting a string with accents

[romain.dev.easycity.com]

Hi guys,

I'm using seam 1.2.1 GA and jboss 4.0.5 GA.

I'm trying pass a String parameter to another page using http.

On the first page, I have a list of cities (some of them contain accents). For exemple, in spain :

VALÈNCIA

I have this link (using facelets) :

<a href="/sitemap/city.seam?country_code=#{city[1]}&amp;city_name=#{city[0]}">#{city[0]}</a>

This is the generated URL :

http://localhost:8080/sitemap/city.seam?country_code=es&city_name=VAL%C3%88NCIA

Then I try to get the value for another query in my session bean :

    <page view-id="/sitemap/city.xhtml" action="#{siteMapManager.initCategoryList}">
         <param name="country_code" value="#{iso3166}"/>
         <param name="city_name" value="#{cityName}"/>
    </page>

@In (required=false)
private String cityName;

An then trying to perform a query using the city name :

// Get Category list
String qCtgListStr =     "SELECT DISTINCT poi.mainCategory.id " +
", ctgDet.name " +
", poi.address.locality " +
", LOWER(poi.country.iso3166) " +
", COUNT (poi.id) " +
"FROM POI as poi " +
" INNER JOIN poi.mainCategory as ctg " +
" INNER JOIN ctg.detailsSet as ctgDet " +
"WHERE poi.revisionState = :revState " +               "          AND ctgDet.locale.id = :locale " +
"          AND poi.country.iso3166 = :countryCode " +
"          AND poi.address.locality = :cityName " +     "GROUP BY poi.mainCategory.id " +
",     ctgDet.name " +
",     poi.address.locality " +
",     poi.country.iso3166 " +
"ORDER BY COUNT (poi.id) DESC";

Query qCtgList = this.em.createQuery(qCtgListStr);
qCtgList.setParameter("countryCode", this.iso3166.toUpperCase());
qCtgList.setParameter("locale", this.locale.toString());
qCtgList.setParameter("cityName", this.cityName);
qCtgList.setParameter("revState", RevisionState.ACT);

this.categorySet = qCtgList.getResultList();

Howerver, I there is an accent issue. The query doesn't use VALÈNCIA with the correct accent.

Do you know how can I do that correctly ?

Thanks in advance.

Romain

[wrzep]

Hi Romain,

What DB do you use? If you use MySQL, then you have to add useUnicode=true and characterEncoding=UTF-8 parmeters to your connection URL.

You may find those tips helpful: http://www.warski.org/blog/?p=4

Cheers,
-Pawel

[romain.dev.easycity.com]

Thank you Pawel !

I found the solution in your post.

The URIEncoding attribute was missing in my tomcat server.xml configuration :

To have them properly handled by Tomcat, you need to edit the server.xml file, which is located:

    * in JBoss 4.0.x: $JBOSS_HOME/server/ <conf> /deploy /jbossweb-tomcat55.sar/server.xml
    * in JBoss 4.2: $JBOSS_HOME/server/ <conf> /deploy /jboss-web.deployer/server.xml

and add to the appropriate <Connector ...> (usually the first one) the following attribute: URIEncoding="UTF-8".

Thank you very much.

Great article !

Romain