users@jersey.java.net

curious query with LIKE in JPA + Jersey

From: Felipe Gaúcho <fgaucho_at_gmail.com>
Date: Tue, 26 May 2009 09:33:27 +0200

I implemented a search method in my web-service, a simple query using
LIKE %foo%, and then I experimented a strange result:

this URL returns some db rows:
http://fgaucho.dyndns.org:8080/footprint-service/user/search?name=Gaucho

this URL doesn't:
http://fgaucho.dyndns.org:8080/footprint-service/user/search?name=Gaúcho

Notice the correct value of the name field in the database is "Felipe Gaúcho"

so, why "Gaucho" matches the name and "Gaúcho" (with character ú) doesn't ?

somewhere between the URL and the database query the character is
being transformed.. now I need to find where........