SQL request returns incorrect french characters

Thread view:

hagar - 02 Nov 2006 16:34 GMT

I am creating a JSP page that queries a database that contain french
characters. The query works fine and records are returned with the
following request:

AND DESIGNATION_FR = "Zone d'utilisation générale"

However somewhere between the response to the query and passing the
information to the browser the e's with the accents get altered as
such:

"Zone d'utilisation ginirale"

I imagine this is some sort of character set issue. Has any resolved
this sort of thing?

Reply to this Message

Tom Forsmo - 02 Nov 2006 16:46 GMT

> I am creating a JSP page that queries a database that contain french
> characters. The query works fine and records are returned with the
[quoted text clipped - 10 lines]
> I imagine this is some sort of character set issue. Has any resolved
> this sort of thing?

I have experienced some problems with character sets in DBs, not the
exact same problem, but still. My suggestion is to check that the
character set is the same in the db config, the table, the connection,
the application and the web page. If they are not the same you might
want to try to apply a conversion, for example at the connection. In
addition you might want to check that the data in the database is of the
correct character set.

tom

Reply to this Message

SQL request returns incorrect french characters

Free Magazines